This message was deleted.
# troubleshootings
Slackbot
02/28/2023, 2:46 AMThis message was deleted.
v
Vijay Narayanan
02/28/2023, 3:53 AMwhat is the requirement? Can you paste a sample query here?
u
추호관
02/28/2023, 3:54 AM@Vijay Narayanan
like
row 1 … queryId = a, query = b
row 2 … queryId = a, query = null
groupBy queryId and get first non null value in this case b
maybe Earliest() ? might be answer?
v
Vijay Narayanan
02/28/2023, 4:04 AMwhat are you ordering on? You could use a having clause to filter out nulls in the inner query and then pick one row from that result in the outer query
u
추호관
02/28/2023, 5:05 AM@Vijay Narayanan there is case that
row 1 … queryId = a, query = b, colA= null
row 2 … queryId = a, query = null, colA=test
in this case i need to get value from row1 and row2
v
Vijay Narayanan
02/28/2023, 6:37 AMshould the output be one row a,b,test or two separate rows?
u
추호관
02/28/2023, 6:48 AM@Vijay Narayanan thanks one row
v
Vijay Narayanan
02/28/2023, 7:53 AM Copy code
elect col1,earliest(col2,16) filter (where col2<>'null'),EARLIEST(col3,16) filter (where col3 <>'null') from test2 group by col1u
추호관
02/28/2023, 8:11 AMgot it … thank you i will use earliest
추호관
02/28/2023, 10:17 AM@Vijay Narayanan filter(where col2 is not null)
Solver the problem and got table what i want thank you