Hive
  1. Hive
  2. HIVE-4659

while sql contains \t , 'desc formatted view_name' and 'show create table view_name' statements will generate Incomplete results

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 0.12.0
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      drop view if exists v_test;
      CREATE VIEW v_test AS select
      key, – start by \t\t
      value, – start by \t\t
      dt from – start by \t\t
      (
      select key, value, dt from tmp_v_t1 where dt='20130122'
      union all
      select key,value, dt from tmp_v_t1 where dt='20130123'
      ) t;

      $ hive -e "show create table v_test"

      UT-One the three lines which started by \t lost in create statment !
      Logging initialized using configuration in file:/home/zongren/hive-conf/hive-log4j.properties
      Hive history file=/tmp/zongren/hive_job_log_zongren_24155@hd17-vm5_201306051125_94165790.txt
      OK
      CREATE VIEW v_test AS select

      (
      select `tmp_v_t1`.`key`, `tmp_v_t1`.`value`, `tmp_v_t1`.`dt` from `default`.`tmp_v_t1` where `tmp_v_t1`.`dt`='20130122'
      union all
      select `tmp_v_t1`.`key`,`tmp_v_t1`.`value`, `tmp_v_t1`.`dt` from `default`.`tmp_v_t1` where `tmp_v_t1`.`dt`='20130123'
      ) `t`
      Time taken: 2.767 seconds, Fetched: 9 row(s)

      UT-Two:

        Issue Links

          Activity

            People

            • Assignee:
              caofangkun
              Reporter:
              caofangkun
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:

                Development