pvary commented on pull request #2947: URL: https://github.com/apache/hive/pull/2947#issuecomment-1074862624
Thanks for the explanation @zzzzming95! This was a misunderstanding on my side. What happens if your query is like this - would the filtering work in this case? ``` select * from src_play_day WHERE dt='20211125' AND u_gtype='activity_workshop' limit 10; ``` Notice that I used `'`-s to convert 20211125 to string. Another question is, how does this work with the other supported backend databases. The issue with directSql is that we have to handle the differences between the SQL engines ourselves. Also what happens when we have different types, like timestamp/binary/struct? Thanks for investigating this issue, and coming up with possible solutions! -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
