You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by qq <98...@qq.com> on 2020/10/30 10:39:53 UTC
IMG_20201030_183051
When I insert data into the hive table through insert into, the following error appears:
Can anyone tell me how to solve it?
回复： IMG_20201030_183051
Posted by qq <98...@qq.com>.
The first time I inserted the data, it was normal, but the second time I used the same command to insert the data, the error occurred.
Hive MetaStore log:
I have checked the data line, the data type is consistent with the table structure
------------------ 原始邮件 ------------------
发件人: "Narayanan Venkateswaran"<vnhive@gmail.com>;
发送时间: 2020年10月30日(星期五) 晚上9:14
收件人: "user"<user@hive.apache.org>;
抄送: "dev"<dev@hive.apache.org>;
主题: Re: IMG_20201030_183051
Hey,
From your screenshot the exception is from StatsTask. Seems like the error happens while storing statistics. Can you query from the hive table to check if the insertion happened ?
If I am right, I think there was a mismatch in the datatype in the table and the value that you tried to insert.
Check,
https://stackoverflow.com/questions/52960942/hive-record-inserted-but-then-get-a-error
https://issues.apache.org/jira/browse/HIVE-20151
Is it possible for you to please paste the failure next time instead of a photo of the screen ?
Thank you,
Narayanan
On Fri, Oct 30, 2020 at 4:38 PM qq <987626311@qq.com> wrote:
When I insert data into the hive table through insert into, the following error appears:
Can anyone tell me how to solve it?
Re: IMG_20201030_183051
Posted by Narayanan Venkateswaran <vn...@gmail.com>.
Hey,
From your screenshot the exception is from StatsTask. Seems like the error
happens while storing statistics. Can you query from the hive table to
check if the insertion happened ?
If I am right, I think there was a mismatch in the datatype in the table
and the value that you tried to insert.
Check,
https://stackoverflow.com/questions/52960942/hive-record-inserted-but-then-get-a-error
https://issues.apache.org/jira/browse/HIVE-20151
Is it possible for you to please paste the failure next time instead of a
photo of the screen ?
Thank you,
Narayanan
On Fri, Oct 30, 2020 at 4:38 PM qq <98...@qq.com> wrote:
> When I insert data into the hive table through insert into, the following
> error appears:
>
> Can anyone tell me how to solve it?
>