sascha-coenen commented on issue #9418: SQL: column references cannot be replaced by constants URL: https://github.com/apache/druid/issues/9418#issuecomment-591707537 I'm getting the following; ``` SQL Error [00000]: Error -1 (00000) : Error while executing SQL "SELECT¶ LOOKUP('some', 'adtype_by_adtypeid') AS tst": Remote driver error: RuntimeException: java.lang.AssertionError: Type mismatch:¶rowtype of new rel:¶RecordType(VARCHAR tst) NOT NULL¶rowtype of set:¶RecordType(VARCHAR NOT NULL tst) NOT NULL -> AssertionError: Type mismatch:¶rowtype of new rel:¶RecordType(VARCHAR tst) NOT NULL¶rowtype of set:¶RecordType(VARCHAR NOT NULL tst) NOT NULL ``` This is with SQL compatible null handling turned OFF. I can check tomorrow what I get back if I have it switched on. I'm beginning to understand that the behaviour under compatible null handling is more important to get right as it is the desired true north state to thave compat mode switched on, but as we experience a performance issue with compat mode, we need to stick with the default mode for now. I'll update the ticket tomorrow when I have access to the cluster again with what I get under compat mode.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
