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

Unexpect behavior for insert when table name is like `db.tab`

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • None
    • SQL
    • None

    Description

      Just meet a strange problem with following sql, it'll overwrite the data instead of appending data.

      insert into table `default.t1` values (1, 2)

      The result is as follows:

      is it a bug or some other things?

      Attachments

        1. image-2022-11-16-10-09-40-766.png
          44 kB
          luoyuxia
        2. image-2022-11-16-10-08-31-699.png
          58 kB
          luoyuxia
        3. image-2022-11-16-10-03-08-559.png
          50 kB
          luoyuxia
        4. image-2022-11-16-09-57-57-461.png
          682 kB
          luoyuxia

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. HIVE-16907 "INSERT INTO" overwrite old data when destination table encapsulated by backquote

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              luoyuxia luoyuxia
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: