Mailing-List: contact core-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: core-dev@hadoop.apache.org
Message-ID: <681655092.1225398884356.JavaMail.jira@brutus>
Date: Thu, 30 Oct 2008 13:34:44 -0700 (PDT)
From: "Edward Capriolo (JIRA)" <jira@apache.org>
To: core-dev@hadoop.apache.org
Subject: [jira] Created: (HADOOP-4553) Create table not accepting COLLECTION
 ITEM DELIMITER
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Create table not accepting COLLECTION ITEM DELIMITER
----------------------------------------------------

                 Key: HADOOP-4553
                 URL: https://issues.apache.org/jira/browse/HADOOP-4553
             Project: Hadoop Core
          Issue Type: Bug
          Components: contrib/hive
    Affects Versions: 0.17.2
         Environment: Using Hive dist from Facebook mirror, not very sure if this is the correct way to file this
            Reporter: Edward Capriolo


COLLECTION ITEMS TERMINATED BY '\t'; always causes an error regardless of what '\t' '5' '\5' etc.
 
hive> create table testlist (id int,name string,favnum ARRAY<int>) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'  COLLECTION ITEMS TERMINATED BY '\t';
java.lang.NumberFormatException: For input string: "    "
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:447)
        at java.lang.Byte.parseByte(Byte.java:151)
        at java.lang.Byte.valueOf(Byte.java:184)
        at java.lang.Byte.valueOf(Byte.java:208)
        at org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol.initialize(TCTLSeparatedProtocol.java:316)
        at org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe.initialize(DynamicSerDe.java:85)
        at org.apache.hadoop.hive.metastore.MetaStoreUtils.getDeserializer(MetaStoreUtils.java:178)
        at org.apache.hadoop.hive.ql.metadata.Table.initSerDe(Table.java:135)
        at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:198)
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:205)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:174)
        at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:183)
        at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:208)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:304)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:155)
        at org.apache.hadoop.mapred.JobShell.run(JobShell.java:194)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
        at org.apache.hadoop.mapred.JobShell.main(JobShell.java:220)

FAILED: Error in metadata: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException java.lang.NumberFormatException: For input string: "  ")
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Time taken: 2.823 seconds


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.