Hello Team,

I was trying to migrate one of the hive query to Drill but stuck on two issues


1)      Drill don't like number in hive database name

Error: PARSE ERROR: Encountered "use 360" at line 1, column 1.



2)      INSERT statement is not recognized
Error: PARSE ERROR: null

"Insert overwrite table table_1
Select * from table_2
"

While looked at documentation, could not see "INSERT" like statement
https://drill.apache.org/docs/supported-sql-commands/

can someone please confirm if this correct behavior of Drill or any other 
workaround possible?

Thanks
Rajesh Balel

  • ... Rajesh Balel -X (rbalel - COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION at Cisco)
    • ... Abhishek Girish
      • ... Rajesh Balel -X (rbalel - COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION at Cisco)
        • ... Abhishek Girish
          • ... Rajesh Balel -X (rbalel - COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION at Cisco)

Reply via email to