You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by upd r <up...@gmail.com> on 2014/08/26 22:19:36 UTC
varchar
Hi,
I have a created a table with fields defined as varchar(length). Is it
correct to insert data in to the table casting the fields as
VARCHAR(length).
I am getting this error.
Error occurred executing hive query: OK FAILED: SemanticException Generate
Map Join Task Error: Class cannot be created (missing no-arg constructor):
org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableHiveVarcharObjectInspector
Serialization trace: objectInspector
(org.apache.hadoop.hive.ql.exec.ColumnInfo) signature
(org.apache.hadoop.hive.ql.exec.RowSchema) rowSchema
(org.apache.hadoop.hive.ql.exec.FileSinkOperator) childOperators
(org.apache.hadoop.hive.ql.exec.SelectOperator) childOperators
(org.apache.hadoop.hive.ql.exec.GroupByOperator) opParseCtxMap
(org.apache.hadoop.hive.ql.plan.MapWork) mapWork
(org.apache.hadoop.hive.ql.plan.MapredWork)
Re: varchar
Posted by Jason Dere <jd...@hortonworks.com>.
What version of Hive?
Do you have some sample SQL?
On Aug 26, 2014, at 1:20 PM, upd r <up...@gmail.com> wrote:
> Hi,
>
> I have a created a table with fields defined as varchar(length). Is it correct to insert data in to the table casting the fields as VARCHAR(length).
>
> I am getting this error.
> Error occurred executing hive query: OK FAILED: SemanticException Generate Map Join Task Error: Class cannot be created (missing no-arg constructor): org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableHiveVarcharObjectInspector Serialization trace: objectInspector (org.apache.hadoop.hive.ql.exec.ColumnInfo) signature (org.apache.hadoop.hive.ql.exec.RowSchema) rowSchema (org.apache.hadoop.hive.ql.exec.FileSinkOperator) childOperators (org.apache.hadoop.hive.ql.exec.SelectOperator) childOperators (org.apache.hadoop.hive.ql.exec.GroupByOperator) opParseCtxMap (org.apache.hadoop.hive.ql.plan.MapWork) mapWork (org.apache.hadoop.hive.ql.plan.MapredWork)
> Please Help!
>
> Thanks in advance,
> UPD
>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: varchar
Posted by upd r <up...@gmail.com>.
Hi,
I have a created a table with fields defined as varchar(length). Is it
correct to insert data in to the table casting the fields as
VARCHAR(length).
I am getting this error.
Error occurred executing hive query: OK FAILED: SemanticException Generate
Map Join Task Error: Class cannot be created (missing no-arg constructor):
org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableHiveVarcharObjectInspector
Serialization trace: objectInspector
(org.apache.hadoop.hive.ql.exec.ColumnInfo) signature
(org.apache.hadoop.hive.ql.exec.RowSchema) rowSchema
(org.apache.hadoop.hive.ql.exec.FileSinkOperator) childOperators
(org.apache.hadoop.hive.ql.exec.SelectOperator) childOperators
(org.apache.hadoop.hive.ql.exec.GroupByOperator) opParseCtxMap
(org.apache.hadoop.hive.ql.plan.MapWork) mapWork
(org.apache.hadoop.hive.ql.plan.MapredWork)
Please Help!
Thanks in advance,
UPD