[
https://issues.apache.org/jira/browse/HIVE-24951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17310376#comment-17310376
]
Nikhil Gupta commented on HIVE-24951:
-------------------------------------
As far as I know hive is case insensitive. The location should be
/warehouse/tablespace/external/hive/my_test.
Can you verify this?
Reference: [User FAQ - Apache Hive - Apache Software
Foundation|https://cwiki.apache.org/confluence/display/Hive/User+FAQ#:~:text=Hive%20is%20case%20insensitive.]
> Table created with Uppercase name using CTAS does not produce result for
> select queries
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-24951
> URL: https://issues.apache.org/jira/browse/HIVE-24951
> Project: Hive
> Issue Type: Bug
> Components: Metastore
> Affects Versions: 4.0.0
> Reporter: Rajkumar Singh
> Assignee: Rajkumar Singh
> Priority: Major
>
> Steps to repro:
> {code:java}
> CREATE EXTERNAL TABLE MY_TEST AS SELECT * FROM source
> Table created with Location but does not have any data moved to it.
> /warehouse/tablespace/external/hive/MY_TEST
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
