vinvcr
2016-05-09 03:08hive问题: pyhs2 load数据报错
Traceback (most recent call last):
File "hive_pyhs2.py", line 23, in
cur.execute("load data local inpath '/home/linqiaoying/e/hive/data/b.txt' overwrite into table student")
File "build/bdist.linux-x86_64/egg/pyhs2/cursor.py", line 64, in execute
pyhs2.error.Pyhs2Exception: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask'
#!/usr/bin/env python
-*- coding: utf-8 -*-
hive util with hive server2
import sys
import pyhs2
from setuptools import setup, Extension
with pyhs2.connect(host='127.0.0.1'',
port=10000,
authMechanism="PLAIN",
user='root',
password='rootroot',
database='default') as conn:
with conn.cursor() as cur:
print cur.getDatabases()
cur.execute("select * from tp_trade_order")
print cur.getSchema()
for i in cur.fetch():
print i
cur.execute("load data local inpath '/home/linqiaoying/e/hive/data/b.txt' overwrite into table student")
cur.close()
- 点赞
- 回答
- 收藏
- 复制链接分享
0条回答
为你推荐
- spring boot 1.5 版本多个hive数据源,无法正常访问
- jar
- java
- spring
- tomcat
- 2个回答
- hive怎么开启支持单条数据的insert支持?是开启事务吗?
- sql
- maven
- intellij-idea
- nosql
- 1个回答
- hive连接mysql数据库用hive命令一直带运行,什么问题?
- 数据库
- hive
- mysql
- 2个回答
- 【hive】SQL问题,4表联查怎么优化,语句太长了
- 数据库
- 优化
- hive
- sql
- mysql
- 3个回答
- 问一个hive查询方面的问题,如果字段里面存的是json字符串,hive可以根据这个查询么?
- java
- json
- hive
- hadoop
- 大数据
- 1个回答