[
https://issues.apache.org/jira/browse/HIVE-23426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17103324#comment-17103324
]
Sureshkumar commented on HIVE-23426:
------------------------------------
*Created View:*
CREATE VIEW <schema_name>.<view_name> AS select * from (select * from
<schema_name>.<table_name_A>) a,<schema_name>.<table_name_B>
b,<schema_name>.<table_name_C> c where a.key = b.key AND b.key=c.key AND
b.<column>=<value> AND c.<column>=<value>
*Viewing view definition*
show create table <schema_name>.<view_name>;
*Result*
CREATE VIEW <schema_name>.<view_name> AS select <50+columns> from (select <50+
columns> from <schema_name>.<table_name_A>) a,<schema_name>.<table_name_B>
b,<schema_name>.<table_name_C> c where a.key = b.key AND
Result is showing only till AND, after that all the strings are missed.
I tried in all ways beeline, direct hive CLI, re-directing the result into
file, etc..
Can you please help?
> Show create table for Views giving incomplete view definition
> -------------------------------------------------------------
>
> Key: HIVE-23426
> URL: https://issues.apache.org/jira/browse/HIVE-23426
> Project: Hive
> Issue Type: Bug
> Reporter: Sureshkumar
> Assignee: Miklos Gergely
> Priority: Major
>
> Show create table for View giving incomplete view definition
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
