I am using hive.  ... View more

Hi @Atul Goel! Did you try the following command? [hive@node3 ~]$ beeline -u 'jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2' --showNestedErrs --showWarnings --verbose -e "select 1 + 1;" 2> /tmp/beeline.out [hive@node3 ~]$ cat /tmp/beeline.out issuing: !connect jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 '' [passwd stripped] Connecting to jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Connected to: Apache Hive (version 1.2.1000.2.6.5.0-292) Driver: Hive JDBC (version 1.2.1000.2.6.5.0-292) Transaction isolation: TRANSACTION_REPEATABLE_READ Executing command: select 1 + 1; Getting log thread is interrupted, since query is done! 1 row selected (0.218 seconds) Beeline version 1.2.1000.2.6.5.0-292 by Apache Hive Closing: 0: jdbc:hive2://node2:2181,node3:2181,node4:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Hope this helps! ... View more

Here is DDL create table if not exists <TABLENAME> ( audit_crz_create_ts timestamp comment "audit trail CRZ load timestamp", zpctyp string comment "code type", zpfcod string comment "currency code", zp_sg079 string comment "filler", zplang string comment "language code", zp_sg080 string comment "filler", zpfdes string comment "currency description", zpfdec int comment "no.of decimal places", zp_sg223 string comment "filler", f_d_cc string comment "delete code", f_r_cc string comment "record id") partitioned by (businesseffectivedate date) row format delimited fields terminated by '\t' lines terminated by '\n' stored as orc location '/data/crz/bb5g/con/<TABLENAME>/'; ... View more