hivesql异常插入不进去数据

arbalest1080 • 2023年09月06日 11:54 • 1年前 • 编程日记 • 阅读(10) • 违法举报

near token'cardNumber' .. errorencountered
23/08/30 15:16:58 ERROR ql.Driver: FAILED: SemanticExceptio on 1:27 '[eventcode, customerId, eventTime, accountNumber, scenario Code, cardNumber]’ in insert schema specification are not f found among regular columns of aaabbb.hive_eventpush nor dynamic pa rtition columns.. Error encountered near token 'cardNumber’
org.apache.hadoop.hive.ql.parse.SemanticException: 1:27 '[e eventCode, customerId, eventTime, accountNumber, scenariocode, card Number]' in insert schema specification are not found among regular columns of aaabbb.hive_eventpush nor dynamic partition co lumns.. Error encountered near token'cardNumber'

FAILED: SemanticException 1:30 '[customerid, car dNumber]' in insert schema specification are not found among regular colum nor dynamic partition columns.. Error encountere ed near token 'cardnumber'

遇到的问题

FAILED: SemanticException 1:46 ‘[field1, field2]’ in insert schema specification are not found among regular columns of databasesName.tableName nor dynamic partition columns… Error encountered near token ‘field2’

解决办法：

原sql
insert into tableName(Field1,Field2) values(‘x1’,‘x2’)

将sql中字段名改为小写
insert into tableName(field1,field2) values(‘x1’,‘x2’)
文章来源地址https://uudwc.com/A/jrrP9

原文地址:https://blog.csdn.net/arbalest1080/article/details/132583385

本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如若转载，请注明出处：如若内容造成侵权/违法违规/事实不符，请联系站长进行投诉反馈，一经查实，立即删除！