Support Questions

Find answers, ask questions, and share your expertise

show create table view_name not showing complete definition of view

avatar
Guru

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)

3 REPLIES 3

avatar
@Saurabh

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)

avatar
Guru

Yes this specific to a big view not a small.

avatar

@Saurabh

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