Hey Rajesh, "Insert into table" is currently not supported. Please watch DRILL-3534 <https://issues.apache.org/jira/browse/DRILL-3534> for updates on this.
And, the "use" statement cannot be used to directly specify hive database name. You will need to use the hive storage plugin for this. Refer to [1] and [2]. [1] https://drill.apache.org/docs/hive-storage-plugin/ [2] https://drill.apache.org/docs/querying-hive/ -Abhishek On Tue, Oct 27, 2015 at 11:31 AM, Rajesh Balel -X (rbalel - COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION at Cisco) <[email protected]> wrote: > 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 > >
