[
https://issues.apache.org/jira/browse/HIVE-29059?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cyan Zheng reassigned HIVE-29059:
---------------------------------
Assignee: Cyan Zheng
> SHOW CREATE TABLE ignores all strings after tab character
> ---------------------------------------------------------
>
> Key: HIVE-29059
> URL: https://issues.apache.org/jira/browse/HIVE-29059
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.1
> Reporter: Paramvir Singh
> Assignee: Cyan Zheng
> Priority: Major
>
> Repro scenario
> 1. Create an external table and insert some data into it
> {code:java}
> create external table if not exists mytable
> (MY_COL1 string, MY_COL2 string, MY_COL3 string)
> row format delimited
> fields terminated by ',';
> INSERT INTO TABLE mytable VALUES
> ('5', '5', '5'),
> ('6', '6', '6');
> {code}
> 2. Use a hql file to create a view, e.g.
> {code:java}
> cat h.sql
> create view mytable_v as select * from mytable where my_col1 = 1; --> Note
> here after my_col there is a tab character (not space character)
> beeline -u "jdbc:hive2://$(hostname -f):10000/default" -n hadoop -f h.sql
> {code}
> 3. Run SHOW CREATE VIEW. Everything after the tab character is ignored
> {code:java}
> 0: jdbc:hive2://ip-172-31-45-90.us-west-2.com> show create table mytable_v;
> INFO : Compiling
> command(queryId=hive_20250702091216_491b1456-84ef-4789-aad6-20d2c0161599):
> show create table mytable_v
> INFO : Semantic Analysis Completed (retrial = false)
> INFO : Created Hive schema:
> Schema(fieldSchemas:[FieldSchema(name:createtab_stmt, type:string,
> comment:from deserializer)], properties:null)
> INFO : Completed compiling
> command(queryId=hive_20250702091216_491b1456-84ef-4789-aad6-20d2c0161599);
> Time taken: 0.043 seconds
> INFO : Concurrency mode is disabled, not creating a lock manager
> INFO : Executing
> command(queryId=hive_20250702091216_491b1456-84ef-4789-aad6-20d2c0161599):
> show create table mytable_v
> INFO : Starting task [Stage-0:DDL] in serial mode
> INFO : Completed executing
> command(queryId=hive_20250702091216_491b1456-84ef-4789-aad6-20d2c0161599);
> Time taken: 0.092 seconds
> +----------------------------------------------------+
> | createtab_stmt |
> +----------------------------------------------------+
> | CREATE VIEW `mytable_v` AS select `mytable`.`my_col1`, `mytable`.`my_col2`,
> `mytable`.`my_col3` from `default`.`mytable` where `mytable`.`my_col1` |
> +----------------------------------------------------+
> 1 row selected (0.332 seconds)
> {code}
> 4. However querying the view still works,
> {code:java}
> select * from mytable_v;
> +--------------------+--------------------+--------------------+
> | mytable_v.my_col1 | mytable_v.my_col2 | mytable_v.my_col3 |
> +--------------------+--------------------+--------------------+
> | 1 | 1 | 1 |
> +--------------------+--------------------+--------------------+
> {code}
> In TBLS table in metastore, it still has the full view creation query, with
> my_col1 = 1
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
