XMLWordPrintableJSON

    Details

      Description

      0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> set hive.create.as.acid;
      ----------------------------

      set

      ----------------------------

      hive.create.as.acid=false

      ----------------------------
      1 row selected (0.018 seconds)
      0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> set hive.create.as.insert.only;
      -----------------------------------

      set

      -----------------------------------

      hive.create.as.insert.only=false

      -----------------------------------
      1 row selected (0.013 seconds)
      0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> create managed table mgd_table(a int);
      INFO : Compiling command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140): create managed table mgd_table(a int)
      INFO : Semantic Analysis Completed (retrial = false)
      INFO : Created Hive schema: Schema(fieldSchemas:null, properties:null)
      INFO : Completed compiling command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140); Time taken: 0.021 seconds
      INFO : Executing command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140): create managed table mgd_table(a int)
      INFO : Starting task [Stage-0:DDL] in serial mode
      INFO : Completed executing command(queryId=hive_20201014053526_9ba1ffa3-3aa2-47c3-8514-1fe58fe4f140); Time taken: 0.048 seconds
      INFO : OK
      No rows affected (0.107 seconds)
      0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si> describe formatted mgd_table;
      INFO : Compiling command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5): describe formatted mgd_table
      INFO : Semantic Analysis Completed (retrial = false)
      INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col_name, type:string, comment:from deserializer), FieldSchema(name:data_type, type:string, comment:from deserializer), FieldSchema(name:comment, type:string, comment:from deserializer)], properties:null)
      INFO : Completed compiling command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5); Time taken: 0.037 seconds
      INFO : Executing command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5): describe formatted mgd_table
      INFO : Starting task [Stage-0:DDL] in serial mode
      INFO : Completed executing command(queryId=hive_20201014053533_8919be7d-41b0-41e5-b9eb-847801a9d8c5); Time taken: 0.03 seconds
      INFO : OK
      -----------------------------------------------------------------------------------------------------------------------------------

      col_name data_type comment

      -----------------------------------------------------------------------------------------------------------------------------------

      a int  
        NULL NULL
      1. Detailed Table Information
      NULL NULL
      Database: bothfalseonhs2 NULL
      OwnerType: USER NULL
      Owner: hive NULL
      CreateTime: Wed Oct 14 05:35:26 UTC 2020 NULL
      LastAccessTime: UNKNOWN NULL
      Retention: 0 NULL
      Location: hdfs://ngangam-3.ngangam.root.hwx.site:8020/warehouse/tablespace/external/hive/bothfalseonhs2.db/mgd_table NULL
      Table Type: EXTERNAL_TABLE NULL
      Table Parameters: NULL NULL
        COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\"}}
        EXTERNAL TRUE
        TRANSLATED_TO_EXTERNAL TRUE
        bucketing_version 2
        external.table.purge TRUE
        numFiles 0
        numRows 0
        rawDataSize 0
        totalSize 0
        transient_lastDdlTime 1602653726
        NULL NULL
      1. Storage Information
      NULL NULL
      SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde NULL
      InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat NULL
      OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat NULL
      Compressed: No NULL
      Num Buckets: -1 NULL
      Bucket Columns: [] NULL
      Sort Columns: [] NULL
      Storage Desc Params: NULL NULL
        serialization.format 1

      -----------------------------------------------------------------------------------------------------------------------------------
      33 rows selected (0.116 seconds)
      0: jdbc:hive2://ngangam-3.ngangam.root.hwx.si>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ngangam Naveen Gangam
                Reporter:
                ngangam Naveen Gangam
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 20m
                  1h 20m