Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id EB24F118CF for ; Tue, 26 Aug 2014 20:21:07 +0000 (UTC) Received: (qmail 96195 invoked by uid 500); 26 Aug 2014 20:21:06 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 96124 invoked by uid 500); 26 Aug 2014 20:21:06 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 96110 invoked by uid 99); 26 Aug 2014 20:21:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Aug 2014 20:21:06 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of updbigdata@gmail.com designates 209.85.223.174 as permitted sender) Received: from [209.85.223.174] (HELO mail-ie0-f174.google.com) (209.85.223.174) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Aug 2014 20:20:39 +0000 Received: by mail-ie0-f174.google.com with SMTP id rp18so12355229iec.19 for ; Tue, 26 Aug 2014 13:20:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=Cfmt7h1ZeDlyCOchF56usVy718WnHF+7lfsMW93DSHo=; b=xH6fCBwGXCLL6sq1zKn8Xbu3HXy4oFh15Y7B2lMq9Y3cQz5xH4e3lyPH1vcgDnDz4y CL93R/K6kTtlWHfgOjIIU9oSTGQiGFs2a0fRJPi7JBeFjvu8H1V8+BQkwLg/7Tgr8ASB ICuD7Lm9+AkA3Fo58z5yPHjo1RzqDkxRUqiAPrY0w3y3ZGK2YBvu3zrEAzdWo2+q3m6R kt9YEiuSJ0ZVPDXS4ZFul/CW+LNkVp76BsETo4pvLSP7KQbXY+Zo+QT2FtetYQzcMrHm +JfwIv0/cSnY1d4cvjffay/I1+MjMk+IGAzz7a0rl/8aoHKifmSrZRRAb7VaPkpR7c4i /8+A== MIME-Version: 1.0 X-Received: by 10.50.176.169 with SMTP id cj9mr24888034igc.14.1409084438383; Tue, 26 Aug 2014 13:20:38 -0700 (PDT) Received: by 10.64.72.137 with HTTP; Tue, 26 Aug 2014 13:20:38 -0700 (PDT) In-Reply-To: References: Date: Tue, 26 Aug 2014 13:20:38 -0700 Message-ID: Subject: Re: varchar From: upd r To: user@hive.apache.org Content-Type: multipart/alternative; boundary=089e0122fa3e68dc4405018e09db X-Virus-Checked: Checked by ClamAV on apache.org --089e0122fa3e68dc4405018e09db Content-Type: text/plain; charset=UTF-8 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 --089e0122fa3e68dc4405018e09db Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

=
I have a c= reated a table with fields defined as varchar(length). Is it correct to ins= ert data in to the table casting the fields as VARCHAR(length).

I am getting this erro= r.
Err= or 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.WritableHiveVarcharObj= ectInspector Serialization trace: objectInspector (org.apache.hadoop.hive.q= l.exec.ColumnInfo) signature (org.apache.hadoop.hive.ql.exec.RowSchema) row= Schema (org.apache.hadoop.hive.ql.exec.FileSinkOperator) childOperators (or= g.apache.hadoop.hive.ql.exec.SelectOperator) childOperators (org.apache.had= oop.hive.ql.exec.GroupByOperator) opParseCtxMap (org.apache.hadoop.hive.ql.= plan.MapWork) mapWork (org.apache.hadoop.hive.ql.plan.MapredWork)
Please Help= !

=
Thanks in a= dvance,=C2=A0
UPD<= /span>

--089e0122fa3e68dc4405018e09db--