Created on 10-18-2017 07:23 AM - edited 09-16-2022 05:25 AM
show create table view_name not showing complete definition of view. and it just show one or two line and then all blank . I can see it is returning 38 rows but can someone please help me why it is not showing on cli.
hive> show create table sample_db.i0001_ivo_hdr;
OK
CREATE VIEW `sample_db.i0001a_ivo_hdr` AS SELECT
Time taken: 0.086 seconds, Fetched: 38 row(s)
Created 10-26-2017 07:42 AM
I verified in my cluster and I am able to see the table structure. Is the issue specific to views created on huge tables?
hive> create view pre_load_table_view as select * from pre_load_table; OK Time taken: 0.386 seconds hive> show create table pre_load_table_view; OK CREATE VIEW `pre_load_table_view` AS select `pre_load_table`.`comp_id`, `pre_load_table`.`item`, `pre_load_table`.`local_supp_code`, `pre_load_table`.`forecast_id`, `pre_load_table`.`transaction_date`, `pre_load_table`.`planned_need_date`, `pre_load_table`.`mfg_partno`, `pre_load_table`.`local_mfg_code`,`pre_load_table`.`forecast_qty_inv`, `pre_load_table`.`forecast_qty_pur`, `pre_load_table`.`purchasing_uom`, `pre_load_table`.`forecast_method`, `pre_load_table`.`b2b_communicated`, `pre_load_table`.`file_name` from `default`.`pre_load_table` Time taken: 0.535 seconds, Fetched: 1 row(s)
Created 10-30-2017 07:38 AM
Yes this specific to a big view not a small.
Created 10-30-2017 12:13 PM
It happens sometimes because of limitation of no of lines displayed in CLI.
try this --> hive -e "show create table sample_db.i0001_ivo_hdr;" > ddl.txt