Hive
  1. Hive
  2. HIVE-3863

with the hbase table,INSERT INTO can't append to the hive table

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 0.9.0
    • Fix Version/s: None
    • Component/s: HBase Handler
    • Labels:
      None
    • Environment:

      ubuntu 12.04 hadoop 1.0.2 hbase 0.94.1 hive 0.9.0

      Description

      https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML
      quote the LanguageManual:
      "
      INSERT OVERWRITE will overwrite any existing data in the table or partition
      unless IF NOT EXISTS is provided for a partition (as of Hive 0.9.0)
      INSERT INTO will append to the table or partition keeping the existing data in tact. (Note: INSERT INTO syntax is only available starting in version 0.8)

      "

      my hql like "insert into table hive_table select xx from hbase_table" and "insert overwrite table hive_table select xx from hbase_table"

      i want to insert data into the hive table from the hbase table. but INSERT INTO can't append to the table, it overwrite the table.

      is it a bug?

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Gallardot.Tan
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development