[jira] [Created] (HIVE-25198) CTAS external table with camelcase & HMS translation ON is returning 0 records

["Naresh P R (Jira)" <ji...@apache.org>]

Naresh P R created HIVE-25198:
---------------------------------

             Summary: CTAS external table with camelcase & HMS translation ON is returning 0 records
                 Key: HIVE-25198
                 URL: https://issues.apache.org/jira/browse/HIVE-25198
             Project: Hive
          Issue Type: Bug
            Reporter: Naresh P R
            Assignee: Naresh P R


create external table TarGet as select * from source;

Above query creates tableLocation with CamelCase if HMS Translation is ON, whereas MoveTask will use lowerCase table path.

eg., 

 
{code:java}
==> Desc formatted target <==
Location:  hdfs:///warehouse/tablespace/external/hive/test.db/TarGet

==> MoveTask <==
INFO : Moving data to directory hdfs:///warehouse/tablespace/external/hive/test.db/target from hdfs:///warehouse/tablespace/external/hive/test.db/.hive-staging_hive_2021-06-04_03-02-36_272_669287187808252905-12/-ext-10002

==> HMS Translation <==
2021-06-04 03:02:45,772 INFO  org.apache.hadoop.hive.metastore.MetastoreDefaultTransformer: [pool-7-thread-8]: Transformer returning table:Table(tableName:TarGet, dbName:test, owner:hive, createTime:1622775765, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:id, type:varchar(10), comment:null)], location: hdfs:///warehouse/tablespace/external/hive/ajay.db/TarGet,{code}
 

Select query after CTAS will return 0 rows because of this.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)