我正在使用下面的查询在配置单元中插入数据。
INSERT INTO TABLE dc_financials_sales (salessourcenbr,
salessourcecountrycode, salesendinginvsalesdate,
itemdeptnbr, basedivcode,
childctrtrackingid, msgreceivedts,
finreportinggroupcode, gateoutuserid,
itemshippedqty, itemshippedqtyuom,
itemupc, outboundchanneltype,
parentctrtrackingid, salespolinenbr,
salesponbr, salesdocid, salesdocumenttype,
totalsalescost, totalsalescostuom,
trailergateoutts, trailernbr,
transportationloadid, saptransactionid,
vnpkqtyineaches, whpkqtyineaches,
whpksellcost, whpksellcostuom,
wmtitemnbr, wmtitemdesc)
VALUES (6086, 'US',
'20191115', 7,
'WM', NULL,
'2019-11-21 09:04:06+0000', 'US',
's0k01wf', 1,
'EA', '28914173184',
'Staplestock', NULL,
NULL, NULL,
'1168337034A', 'CO',
100, 'USD',
'2019-11-15 13:39:38+0000', NULL,
NULL, '20191121090405332000000v7bG3NGSALEUS6086',
1, 1,
100, 'USD',
'570495975', 'DISNEY PRINCESS ROYA');
但是,得到错误:
Your query has the following error(s):
Error while compiling statement: FAILED:
SemanticException 1:38 '[salessourcenbr, salessourcecountrycode, salesendinginvsalesdate]' in insert schema specification are not found among regular columns of default.dc_financials_sales nor dynamic partition columns.
Error encountered near token 'wmtitemdesc'
有人能帮我理解为什么查询在hive中不起作用吗?
1条答案
按热度按时间zfycwa2u1#
配置单元不支持在中指定普通(非分区)列
INSERT VALUES
声明。请参阅配置单元语言手册:…必须为表中的每一列提供值。尚不支持允许用户仅在某些列中插入值的标准sql语法。为了模仿标准sql,可以为用户不希望赋值的列提供null。