Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21883

Cannot use CTAS for managed table backed by Druid for Hive on Spark

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.3.5
    • Fix Version/s: None
    • Component/s: Druid integration
    • Labels:
      None
    • Environment:

      Hive version: 2.3.5

      Druid version: 0.14.2

      Execution engine Spark: 2.4.1

      Description

      Run the following CTAS:

      "CREATE TABLE district

      STORED BY 'org.apache.hadoop.hive.druid.DruidStorageHandler'

      AS SELECT dt_cre as `__time`, dis_code, dis_desc FROM finwiz_cdc.tu_district"

       

      PS1. Where dt_cre is timestamp, dis_code and dis_desc are string.

      PS2. Please find an attached error from hive

        Attachments

        1. error_from_hive_server.txt
          6 kB
          Peeranut Ngaorungsri
        2. error_from_hive_server_2.txt
          6 kB
          Peeranut Ngaorungsri

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              peeranut.ng Peeranut Ngaorungsri
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: