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

Hive create query is not working when odd number of column name have apostrophe(')

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.3.6
    • None
    • CLI
    • None

    Description

      Hive create table is not working when column name have apostrophe('). This happens only when the numbers of columns are odd.  

      hive> create table `test_table` (`i'd` int, `i'd1` int); 
      OK
      Time taken: 1.662 seconds
      hive> describe `test_table`;
      OK
      i'd                     int                                         
      i'd1                    int                                         
      Time taken: 0.129 seconds, Fetched: 2 row(s)
      hive> create table `test_table1` (`i'd` int); 
      FAILED: ParseException line 1:38 extraneous input ';' expecting EOF near '<EOF>'
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            hetashvipatel7 Hetashvi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: