Hive external table ddl:
Path /data/my_tb contains sub directory and file in it: /data/my_tbl/sub_dir/data.txt with the following data:
When querying such table from Hive, user gets the following exception:
To be able to query this table user needs to set two properties to true: hive.mapred.supports.subdirectories and mapred.input.dir.recursive.
They can be set at system level in hive-site.xml or at session in Hive console:
Currently to be able to query such table from Drill, user can specify this properties in Hive plugin only:
This Jira aims to add new session option to Drill store.hive.conf.properties which will allow user to specify hive properties at session level.
User should write properties in string delimited by new line symbol. Properties values should NOT be set in double-quotes or any other quotes otherwise they would be parsed incorrectly. Property name and value should be separated by =. Each `alter session set` will override previously set properties at session level. If during query Drill couldn't unparse property string, warning will be logged. Properties will be parsed by loading into java.util.Properties. Default value is empty string ("").