Query- select `(processing_dttm)?+.+` from acme_inc_5.trialbalance2017_case_4_wrangler_1533643070304 fails due to null. But when I run the same query in hive, it executes successfully. I have added added the property hive.support.quoted.identifiers=processing_dttm in hive-site.xml
Not able to reproduce the same issue with quoted identifiers,
select `(processing_dttm)?+.+` from acme_inc_5.trialbalance2017_case_4_wrangler_1533643070304
Try configuring HiveConnection pool with the below parameter and execute the query again
it worth to check with this property also in your hive connection pool
Did you tried with CSV/Avro Output formats?
Please share Select HiveQL configs, HiveConnection pool configs and
hive> describe formatted acme_inc_5.trialbalance2017_case_4_wrangler_1533643070304;
When I tried the same changes on selecthiveql processor 1.4.0, it works fine but I get null pointer exception in selecthiveql processor 1.6.0. Is there any specific change that needs to be done in 1.6.0 go get issue resolved?