vinvcr 2016-05-09 03:08
浏览 1728

hive问题: 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条回答

    报告相同问题?

    悬赏问题

    • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
    • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
    • ¥15 如何处理复杂数据表格的除法运算
    • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
    • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
    • ¥200 uniapp长期运行卡死问题解决
    • ¥15 latex怎么处理论文引理引用参考文献
    • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
    • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?
    • ¥15 乘性高斯噪声在深度学习网络中的应用