Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-1520

The table is null when using import into hive as parquet file and query option

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.4.5
    • 1.4.6
    • hive-integration
    • None

    Description

      sh sqoop import --connect jdbc:mysql://server-391/test --username admin --password admin --target-dir /user/pkhadloya/sqoop/extusersegments --hive-import --hive-table extusersegments --create-hive-table --as-parquetfile --query "select * from test where \$CONDITIONS" --split-by id
      
      hive
      0: jdbc:hive2://server-393:10000/default> show tables;
      +-----------+--+
      | tab_name  |
      +-----------+--+
      | null      |
      +-----------+--+
      1 row selected (0.041 seconds)
      0: jdbc:hive2://server-393:10000/default> select * from null;
      +----------+------------+--+
      | null.id  | null.name  |
      +----------+------------+--+
      | 1        | richard    |
      +----------+------------+--+
      1 row selected (2.062 seconds)
      

      Attachments

        1. hive-site.xml
          10 kB
          Pratik Khadloya
        2. hadoop-hadoop-tasktracker-xxx.log
          81 kB
          Pratik Khadloya
        3. diff.patch
          0.8 kB
          Richard

        Activity

          People

            richard_zhou Richard
            richard_zhou Richard
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: