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

insert fails if target table columns are not lowercase

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.1
    • Fix Version/s: 3.0.0
    • Component/s: None
    • Labels:
      None
    • Target Version/s:

      Description

      eg.,
      INSERT INTO TABLE EMP(ID,NAME) select * FROM SRC;
      FAILED: SemanticException 1:27 '[ID,NAME]' in insert schema specification are not found among regular columns of default.EMP nor dynamic partition columns.. Error encountered near token 'NAME'

      Whereas below insert is successful:
      INSERT INTO TABLE EMP(id,name) select * FROM SRC;

        Attachments

        1. HIVE-17845.patch
          3 kB
          Naresh P R

          Issue Links

            Activity

              People

              • Assignee:
                nareshpr Naresh P R
                Reporter:
                nareshpr Naresh P R
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: