[jira] [Commented] (HIVE-23115) SQL with "WITH" clause not suppoting Uppercase table name while creating Views
[
https://issues.apache.org/jira/browse/HIVE-23115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17072039#comment-17072039
]
Dilip Kumar commented on HIVE-23115:
[~prasad-acit], I use beeline version - 2.1.1 and have not tried in the latest
version.
If it is working in the latest versions, can i know from which version it works
properly.
> SQL with "WITH" clause not suppoting Uppercase table name while creating Views
> --
>
> Key: HIVE-23115
> URL: https://issues.apache.org/jira/browse/HIVE-23115
> Project: Hive
> Issue Type: Bug
> Components: Beeline
>Affects Versions: 2.1.1
>Reporter: Dilip Kumar
>Priority: Minor
>
> *Beeline version 2.1.1-mapr-1912*
> SQL with "WITH" clause not suppoting Uppercase table name while creating Views
> Below query creates the VIEW successfully,
> CREATE VIEW default.TEST_VIEW as
> with TEMP_TABLE as (select col1,col2 from table1)
> SELECT col1 from TEMP_TABLE limit 1;
> but when I execute select query on the view throws below error
> {color:#FF}Error: Error while compiling statement: FAILED:
> SemanticException Line 3:90 Table not found 'TEMP_TABLE' in definition of
> VIEW TEST_VIEW{color}
>
> When you replace uppercase TEMP_TABLE to lower case temp_table and query the
> Vew-TEST_VIEW it works,
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (HIVE-23115) SQL with "WITH" clause not suppoting Uppercase table name while creating Views
[
https://issues.apache.org/jira/browse/HIVE-23115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17072026#comment-17072026
]
Renukaprasad C commented on HIVE-23115:
---
[~venkatadilip], i run the query with latest hive release, i didnt face any
issue. Did you verify with higher version?
> SQL with "WITH" clause not suppoting Uppercase table name while creating Views
> --
>
> Key: HIVE-23115
> URL: https://issues.apache.org/jira/browse/HIVE-23115
> Project: Hive
> Issue Type: Bug
> Components: Beeline
>Affects Versions: 2.1.1
>Reporter: Dilip Kumar
>Priority: Minor
>
> *Beeline version 2.1.1-mapr-1912*
> SQL with "WITH" clause not suppoting Uppercase table name while creating Views
> Below query creates the VIEW successfully,
> CREATE VIEW default.TEST_VIEW as
> with TEMP_TABLE as (select col1,col2 from table1)
> SELECT col1 from TEMP_TABLE limit 1;
> but when I execute select query on the view throws below error
> {color:#FF}Error: Error while compiling statement: FAILED:
> SemanticException Line 3:90 Table not found 'TEMP_TABLE' in definition of
> VIEW TEST_VIEW{color}
>
> When you replace uppercase TEMP_TABLE to lower case temp_table and query the
> Vew-TEST_VIEW it works,
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
