[
https://issues.apache.org/jira/browse/HIVE-25198?focusedWorklogId=633237&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-633237
]
ASF GitHub Bot logged work on HIVE-25198:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 04/Aug/21 00:08
Start Date: 04/Aug/21 00:08
Worklog Time Spent: 10m
Work Description: github-actions[bot] commented on pull request #2350:
URL: https://github.com/apache/hive/pull/2350#issuecomment-892250767
This pull request has been automatically marked as stale because it has not
had recent activity. It will be closed if no further activity occurs.
Feel free to reach out on the [email protected] list if the patch is in
need of reviews.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 633237)
Time Spent: 0.5h (was: 20m)
> CTAS external table with camelcase and 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
> Priority: Major
> Labels: pull-request-available
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> 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/test.db/TarGet,{code}
> After CTAS, Select query on target table will return 0 rows.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
