This message was deleted.
# troubleshootings
Slackbot
05/30/2023, 5:06 PMThis message was deleted.
a
Abhishek Agarwal
05/30/2023, 5:49 PMcan you share the full query?
a
Abhishek Balaji Radhakrishnan
05/30/2023, 6:00 PM@cactus - yep, a full query will be good. In general, you can ingest boolean fields as either a string or long type as there’s no real boolean data type in Druid. If you’re using an extern function in your SQL query, the types should be specified in the row signature as documented here
c
cactus
05/30/2023, 6:27 PMAha I've noticed on the ingestion spec that boolean isn't actually listed as a viable choice. I'd added given a type spec containing "bool"
cactus
05/30/2023, 6:28 PMPresumably you'd have to convert the type to a boolean in the SELECT statement similar to how
__timea
Abhishek Balaji Radhakrishnan
05/30/2023, 6:43 PMah, if you want the query to return bool type, I think you could use the
CASE Copy code
CASE WHEN some_boolean_property = 'true' THEN TRUE ELSE FALSEAbhishek Balaji Radhakrishnan
05/30/2023, 6:44 PMNot sure if a Druid function/expression at query time would do the same
c
cactus
05/30/2023, 8:17 PMHaving loaded the value as a
long👍 1