[hadoop@master hive_dat]$ hive
Logging initialized using configuration in file:/app/hive/conf/hive-log4j.properties
Hive history file=/tmp/hadoop/hive_job_log_hadoop_201212181216_2004188466.txt
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
NestedThrowables:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
hive> select * from report_im_push_msg_log limit 10;
FAILED: Error in semantic analysis: Unable to fetch table report_im_push_msg_log
hive> exit;
[hadoop@master hive_dat]$
[hadoop@master hive_dat]$ l;l
-bash: l: command not found
-bash: l: command not found
[hadoop@master hive_dat]$ ll
total 2892096
-rw-r--r-- 1 hadoop hadoop 195602 Dec 14 00:01 197_rp-login-20121214-1.log
-rw-r--r-- 1 hadoop hadoop 1857051 Dec 14 00:18 199_rp-login-20121214-1.log
-rw-r--r-- 1 hadoop hadoop 2947758976 Aug 27 15:12 applist_20120802.txt
-rw-rw-r-- 1 hadoop hadoop 357 Dec 18 12:16 derby.log
drwxrwxr-x 2 hadoop hadoop 36864 Dec 18 12:06 getui
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:56 local_out.dat
drwxrwxr-x 5 hadoop hadoop 4096 Dec 18 12:16 metastore_db
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 17:55 package_name
-rw-rw-r-- 1 hadoop hadoop 8728523 Dec 17 11:11 test.dat
[hadoop@master hive_dat]$
[hadoop@master hive_dat]$ cd metastore_db/
[hadoop@master metastore_db]$ ll
total 24
-rw-rw-r-- 1 hadoop hadoop 4 Dec 18 12:10 dbex.lck
-rw-r--r-- 1 root root 38 Dec 18 12:10 db.lck
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:30 log
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:34 seg0
-rw-rw-r-- 1 hadoop hadoop 846 Dec 14 15:30 service.properties
drwxrwxr-x 2 hadoop hadoop 4096 Dec 18 12:16 tmp
[hadoop@master metastore_db]$ mv dbex.lck 1218dbex.lck
[hadoop@master metastore_db]$ mv db.lck 1218db.lck
[hadoop@master metastore_db]$ cd ..
[hadoop@master hive_dat]$ hive
Logging initialized using configuration in file:/app/hive/conf/hive-log4j.properties
Hive history file=/tmp/hadoop/hive_job_log_hadoop_201212181217_369609033.txt
hive> show tables;
OK
app_list
report_cm_login_log
report_im_push_msg_log
Time taken: 4.26 seconds
hive> select * from report_im_push_msg_log limit 10;
OK
Logging initialized using configuration in file:/app/hive/conf/hive-log4j.properties
Hive history file=/tmp/hadoop/hive_job_log_hadoop_201212181216_2004188466.txt
hive> show tables;
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
NestedThrowables:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
hive> select * from report_im_push_msg_log limit 10;
FAILED: Error in semantic analysis: Unable to fetch table report_im_push_msg_log
hive> exit;
[hadoop@master hive_dat]$
[hadoop@master hive_dat]$ l;l
-bash: l: command not found
-bash: l: command not found
[hadoop@master hive_dat]$ ll
total 2892096
-rw-r--r-- 1 hadoop hadoop 195602 Dec 14 00:01 197_rp-login-20121214-1.log
-rw-r--r-- 1 hadoop hadoop 1857051 Dec 14 00:18 199_rp-login-20121214-1.log
-rw-r--r-- 1 hadoop hadoop 2947758976 Aug 27 15:12 applist_20120802.txt
-rw-rw-r-- 1 hadoop hadoop 357 Dec 18 12:16 derby.log
drwxrwxr-x 2 hadoop hadoop 36864 Dec 18 12:06 getui
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:56 local_out.dat
drwxrwxr-x 5 hadoop hadoop 4096 Dec 18 12:16 metastore_db
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 17:55 package_name
-rw-rw-r-- 1 hadoop hadoop 8728523 Dec 17 11:11 test.dat
[hadoop@master hive_dat]$
[hadoop@master hive_dat]$ cd metastore_db/
[hadoop@master metastore_db]$ ll
total 24
-rw-rw-r-- 1 hadoop hadoop 4 Dec 18 12:10 dbex.lck
-rw-r--r-- 1 root root 38 Dec 18 12:10 db.lck
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:30 log
drwxrwxr-x 2 hadoop hadoop 4096 Dec 14 15:34 seg0
-rw-rw-r-- 1 hadoop hadoop 846 Dec 14 15:30 service.properties
drwxrwxr-x 2 hadoop hadoop 4096 Dec 18 12:16 tmp
[hadoop@master metastore_db]$ mv dbex.lck 1218dbex.lck
[hadoop@master metastore_db]$ mv db.lck 1218db.lck
[hadoop@master metastore_db]$ cd ..
[hadoop@master hive_dat]$ hive
Logging initialized using configuration in file:/app/hive/conf/hive-log4j.properties
Hive history file=/tmp/hadoop/hive_job_log_hadoop_201212181217_369609033.txt
hive> show tables;
OK
app_list
report_cm_login_log
report_im_push_msg_log
Time taken: 4.26 seconds
hive> select * from report_im_push_msg_log limit 10;
OK