I understand, actually it's run on remote servers, and we don't have that much privileges to access the logs. Basically my only concern is whether i can run a query like = " CREATE EXTERNAL TABLE as SELECT * from DemoTable STORED BY "org.elasticsearch.hadoop.hive.EsStorageHandler" TBLPROPERTIES(...) ; ".
This will basically allow me to avoid specifying column name and types and will pickup from an existing table. The reason why i require this is to avoid writing 100 columns. Currently these type of queries are supported by EXTERNAL NATIVE TABLES< but since this is now being stored as external non-native table, i am not sure as how to achieve my target of using existing table schema while creation of table.
It would be a lot helphul if you could provide a workaround for this or route me towards correct person who might be better able to understand my issue and resolve it.
Thanks