- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
show create table view_name not showing complete definition of view
- Labels:
-
Apache Hive
Created on ‎10-18-2017 07:23 AM - edited ‎09-16-2022 05:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes this specific to a big view not a small.
Created ‎10-30-2017 12:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
