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)
