I am trying to run use db_name;show tables and it is failing.  Can you please help me with it  [root@cupid ~]# sudo -u hive beeline -u "jdbc:hive2://charon.devemc.com:2181,cupid.devemc.com:2181,portia.devemc.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;" --showHeader=false --outputformat=tsv2 --delimiter=';' -e "use default;show tables;" scan complete in 2ms Connecting to jdbc:hive2://charon.devemc.com:2181,cupid.devemc.com:2181,portia.commvault.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2; Connected to: Apache Hive (version 0.14.0.2.2.9.0-3393) Driver: Hive JDBC (version 0.14.0.2.2.9.0-3393) Transaction isolation: TRANSACTION_REPEATABLE_READ Error: Error while compiling statement: FAILED: ParseException line 1:11 missing EOF at ';' near 'default' (state=42000,code=40000) ... View more

i am trying to check the files that are created under data folder when we export table to hdfs location. I have single column table with 5000 rows but after export it created only one data file named as 000000_0 I have another table with partition, 2 partitions with 95 rows each approx. and for this table export is see 2 folders each for partition and then under it only one file.  Can you please help me to know how are the data files for the exported table are created and how is it distributed?  I mean is it only one data file for each table without partitioned? or it will create multiple files based on specific row count or size count or on what criteria it is split? ... View more