hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devansh Srivastava <Devansh.Srivast...@datametica.com>
Subject Re: Read error : Varchar cannot be cast to string
Date Fri, 19 Jun 2015 07:55:49 GMT
Hi,

ATLAS JIRA has been closed by admin and I raised separate jira(HIVE-11054) for HIVE project.

Please look into this.

With Regards
Devansh

________________________________________
From: Gopal Vijayaraghavan <gopal@hortonworks.com> on behalf of Gopal Vijayaraghavan
<gopalv@apache.org>
Sent: Thursday, June 18, 2015 8:47 PM
To: user@hive.apache.org
Subject: Re: Read error : Varchar cannot be cast to string

Hi,

I donĀ¹t think I have the privileges to move an ATLAS JIRA into HIVE.

And the pre-commit tests for HIVE do not run for ATLAS issues.

If you have access to the JIRA admin for that project, please move that
issue over into the right project.

Cheers,
Gopal

On 6/18/15, 4:11 AM, "Devansh Srivastava"
<Devansh.Srivastava@datametica.com> wrote:

>Gopal,
>
>I have raised the bug (ATLAS-27).
>
>Thanks,
>Devansh
>
>________________________________________
>From: Devansh Srivastava <Devansh.Srivastava@datametica.com>
>Sent: Thursday, June 18, 2015 4:05 PM
>To: user@hive.apache.org
>Subject: Re: Read error : Varchar cannot be cast to string
>
>Hi Gopal,
>
>Yes, one of the partition column is having VARCHAR as datatype.
>
>My target table has structure like this :--
>
>CREATE EXTERNAL TABLE test_table(
>  dob string COMMENT '',
>  version_nbr int COMMENT '',
>  record_status string COMMENT '',
>  creation_timestamp timestamp COMMENT '')
>PARTITIONED BY (
>  src_sys_cd varchar(10) COMMENT '',batch_id string COMMENT '')
>ROW FORMAT DELIMITED
>  FIELDS TERMINATED BY '|'
>STORED AS ORC
>LOCATION
>  '/test/test_table';
>
>My source table has structure like below :--
>
>CREATE EXTERNAL TABLE test_staging_table(
>  dob string COMMENT '',
>  version_nbr int COMMENT '',
>  record_status string COMMENT '',
>  creation_timestamp timestamp COMMENT ''
>  src_sys_cd varchar(10) COMMENT '',
>batch_id string COMMENT '')
>ROW FORMAT DELIMITED
>  FIELDS TERMINATED BY '|'
>STORED AS ORC
>LOCATION
>  '/test/test_staging_table';
>
>We were loading data using pig script. Its a direct load, no
>transformation needed. But when i was checking test_table's data in hive.
>It is giving previously mentioned error.
>
>With Regards
>Devansh
>________________________________________
>From: Gopal Vijayaraghavan <gopal@hortonworks.com> on behalf of Gopal
>Vijayaraghavan <gopalv@apache.org>
>Sent: Wednesday, June 17, 2015 8:20 PM
>To: user@hive.apache.org
>Subject: Re: Read error : Varchar cannot be cast to string
>
>Hi,
>
>> Caused by: java.lang.ClassCastException:
>>org.apache.hadoop.hive.common.type.HiveVarchar cannot be cast to
>>java.lang.String
>>        at
>>org.apache.hadoop.hive.ql.exec.vector.VectorizedRowBatchCtx.addPartitionC
>>o
>>lsToBatch(VectorizedRowBatchCtx.java:566)
>
>Is it a partition column the one marked as a varchar?
>
>Can you write a small test-case and post a bug about this?
>
>I can take a look at this, looks like a simple missed call to toString().
>
>Cheers,
>Gopal


Mime
View raw message