HIVE BUG: FAILED - NullPointerException null

在运行HIVE 0.13.0时遇到FAILED - NullPointerException,原因是该版本不支持INSERT INTO TABLE SELECT语句而没有FROM子句。此问题被确认为HIVE自身的BUG。解决方法是在语句中添加一个空的目标表。相关BUG报告可在Apache邮件列表和论坛找到。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

  • 运行代码
DESC test_double_to_string;
  • 得到结果
    这里写图片描述

  • 运行代码

INSERT INTO TABLE test_double_to_string SELECT 1 AS num1, 1.01 AS num2, '1,01' AS num3;
  • 得到错误
    这里写图片描述

  • 原因分析
    HIVE 0.13.0不支持直接INSERT INTO TABLE SELECT 而没有FROM一个目标

[ERROR] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[197] - [INFO] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[154] - script execute success [INFO] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[71] - check start result at times 1 [INFO] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[175] - execute shell command : [sh, bin/launcher, status] [INFO] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[182] - Running as 14775 [INFO] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[154] - script execute success [INFO] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[74] - start success in trino-451 [ERROR] 2025-06-11 09:34:31 TaskLogLogger-TRINO-TrinoCoordinator:[197] - [INFO] 2025-06-11 09:52:11 TaskLogLogger-TRINO-TrinoCoordinator:[175] - execute shell command : [sh, bin/launcher, status] [INFO] 2025-06-11 09:52:11 TaskLogLogger-TRINO-TrinoCoordinator:[182] - Running as 14775 [INFO] 2025-06-11 09:52:11 TaskLogLogger-TRINO-TrinoCoordinator:[154] - script execute success [ERROR] 2025-06-11 09:52:11 TaskLogLogger-TRINO-TrinoCoordinator:[197] - [INFO] 2025-06-11 09:52:11 TaskLogLogger-TRINO-TrinoCoordinator:[175] - execute shell command : [sh, bin/launcher, stop] [INFO] 2025-06-11 09:53:54 TaskLogLogger-TRINO-TrinoCoordinator:[175] - execute shell command : [sh, bin/launcher, status] [INFO] 2025-06-11 09:53:54 TaskLogLogger-TRINO-TrinoCoordinator:[182] - Running as 14775 [ERROR] 2025-06-11 09:53:54 TaskLogLogger-TRINO-TrinoCoordinator:[197] - [INFO] 2025-06-11 09:53:54 TaskLogLogger-TRINO-TrinoCoordinator:[154] - script execute success [INFO] 2025-06-11 09:53:54 TaskLogLogger-TRINO-TrinoCoordinator:[59] - trino-451 already started 什么问题
最新发布
06-12
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值