hive jdbc 例子及遇到问题

呼呼，解决hive的jdbc问题花了将近一天，而且解决办法竟然是这么的简单

遇到问题

select * from flag where 1 =1  and cust_no = ‘A3325221981121080410‘  limit 5java.sql.SQLException: Error while processing statement: FAILED: RuntimeException org.apache.hadoop.security.AccessControlException: Permission denied: user=anonymous, access=WRITE, inode="/tmp/hive-hive":hive:hdfs:drwxr-xr-x
	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:234)
	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:214)
	at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:158)
	at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:5202)
	at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:5184)

查看权限

[root@HADOOP7 ~]# hadoop fs -ls /tmp
Found 5 items
drwxr-xr-x   - hdfs          hdfs          0 2014-10-22 17:06 /tmp/hive-hdfs
drwxr-xr-x   - hive          hdfs          0 2014-09-22 10:41 /tmp/hive-hive
drwxr-xr-x   - root          hdfs          0 2014-10-28 10:50 /tmp/hive-root
-rw-r--r--   3 Administrator hdfs          3 2014-09-01 16:18 /tmp/qq.txt
-rw-r--r--   3 Administrator hdfs         20 2014-09-03 11:08 /tmp/test.txt

　修改权限

[root@HADOOP7 ~]# hadoop dfs -chmod -R 755 /tmp/