I have the hive-jdbc.jar file but still the compiler cant find it . -rw-r--r-- 1 root root 110242 Nov 29 2016 /usr/hdp/2.5.3.0-37/hive2/lib/hive-jdbc-2.1.0.2.5.3.0-37.jar [hdfs@hadoop1 ~]$ [hdfs@hadoop1 ~]$ javac -cp /usr/hdp/2.5.3.0-37/hive2/lib/hive-jdbc.jar HiveAlterRenameTo.java HiveAlterRenameTo.java:13: error: unreported exception ClassNotFoundException; must be caught or declared to be thrown Class.forName(driverName); ^ code is as below: [hdfs@hadoop1 ~]$ more HiveAlterRenameTo.java import java.sql.SQLException; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import java.sql.DriverManager; public class HiveAlterRenameTo { private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver"; public static void main(String[] args) throws SQLException { // Register driver and create driver instance Class.forName(driverName); // get connection Connection con = DriverManager.getConnection("jdbc:hive://localhost:10000/default", "", ""); // create statement Statement stmt = con.createStatement(); // execute statement stmt.executeQuery("ALTER TABLE tab1_ORC RENAME TO tab1;"); System.out.println("Table Renamed Successfully"); con.close(); } } ... View more

i am setting this parameter to use 32 mappers but its still using one hive> set map.reduce.tasks=32 > explain select sum(amnt) from lanetxn; OK Plan not optimized by CBO. Vertex dependency in root stage Reducer 2 <- Map 1 (SIMPLE_EDGE) Stage-0 Fetch Operator limit:-1 Stage-1 Reducer 2 ... View more

i have a table with 1 million rows and i can select from it but when i try count(*) from hive it shows 0 rows ? hive> select txn_id,msg_id from pa_lane_txn limit 10; OK 19651715642 PRKG 19651715644 TTOL 19651715646 ETKT 19651715648 TTOL 19651715650 TTOL 19651715654 XTKT 19651715656 XTKT 19651715658 TTOL 19651715660 TTOL 19651715662 TTOL Time taken: 0.142 seconds, Fetched: 10 row(s) hive> select count(*) from pa_lane_txn; OK 0 Time taken: 0.083 seconds, Fetched: 1 row(s) hive> ... View more