Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-9267

[importer] Hue UI sends Multiple create Table commands when table is imported via UI

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.7.0
    • Fix Version/s: None
    • Component/s: app.importer
    • Labels:
      None

      Description

      Problem statement  :  I am trying to import a table via csv file and using the table importer in Hue UI , i can see from hive logs that Hue has send create table Command twice and also the network Tab in chrome shows me Hue is sending the create table command twice

      Issue is reproducible in Hue 4.4.0 and Hue 4.5.0

      The below screenshot shows table is created twice

       

       Below are the Logs shown on Hue UI .

      INFO : Compiling command(queryId=hive_20200421084308_456f8519-b67f-4768-be47-385003ce2aa0): CREATE TABLE `test_import`.`201402_station`
       (
       `ID` bigint ,
       `Name` string ) ROW FORMAT DELIMITED
       FIELDS TERMINATED BY ','
       COLLECTION ITEMS TERMINATED BY '\002'
       MAP KEYS TERMINATED BY '\003'
       STORED AS TextFile TBLPROPERTIES("skip.header.line.count" = "1")
       INFO : Semantic Analysis Completed
       INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
       INFO : Completed compiling command(queryId=hive_20200421084308_456f8519-b67f-4768-be47-385003ce2aa0); Time taken: 0.027 seconds
       INFO : Executing command(queryId=hive_20200421084308_456f8519-b67f-4768-be47-385003ce2aa0): CREATE TABLE `test_import`.`201402_station`
       (
       `ID` bigint ,
       `Name` string ) ROW FORMAT DELIMITED
       FIELDS TERMINATED BY ','
       COLLECTION ITEMS TERMINATED BY '\002'
       MAP KEYS TERMINATED BY '\003'
       STORED AS TextFile TBLPROPERTIES("skip.header.line.count" = "1")
       INFO : Starting task [Stage-0:DDL] in serial mode
       ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. AlreadyExistsException(message:Table 201402_station already exists)
       INFO : Completed executing command(queryId=hive_20200421084308_456f8519-b67f-4768-be47-385003ce2aa0); Time taken: 0.026 seconds

        Attachments

          Activity

            People

            • Assignee:
              johan.ahlen Johan Åhlén
              Reporter:
              asnaik Akhil S Naik
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: