Cool. It works with back quotes Thanks a lot Abhishek Regards Rajesh Balel [email protected] Enterprise Hadoop Application Support
-----Original Message----- From: Abhishek Girish [mailto:[email protected]] Sent: Tuesday, October 27, 2015 12:31 PM To: [email protected] Subject: Re: "Insert" statement and number in hive dbname for Drill Can you enclose it in back quotes and try again? > use hive.`123d`; *+-------+----------------------------------------+* *| ** ok ** | ** summary ** |* *+-------+----------------------------------------+* *| *true * | *Default schema changed to [hive.123d] * |* *+-------+----------------------------------------+* 1 row selected (0.506 seconds) 0: jdbc:drill:drillbit=10.10.104.57> show tables; *+---------------+-------------+* *| **TABLE_SCHEMA ** | **TABLE_NAME ** |* *+---------------+-------------+* *| *hive.123d * | *a1 * |* *+---------------+-------------+* 1 row selected (0.861 seconds) 0: jdbc:drill:drillbit=10.10.104.57> select * from hive.`123d`.a1 limit 1; *+----+* *| **a ** |* *+----+* *| *1 * |* *+----+* 1 row selected (1.195 seconds) On Tue, Oct 27, 2015 at 12:10 PM, Rajesh Balel -X (rbalel - COGNIZANT TECHNOLOGY SOLUTIONS US CORPORATION at Cisco) <[email protected]> wrote: > Thanks Abhishek > > > > Number in name issue occurs when DB name starts with number. It is ok > if number is in between somewhere > > > > use hive.123drill; > > Error: PARSE ERROR: Encountered ".123" at line 1, column 9. > > Was expecting one of: > > <EOF> > > "." ... > > "[" ... > > > > > > use hive.drill_test123; > > +-------+-------------------------------------------------+ > > | ok | summary | > > +-------+-------------------------------------------------+ > > | true | Default schema changed to [hive.drill_test123] | > > +-------+-------------------------------------------------+ > > 1 row selected (2.703 seconds) > > > > Thanks > > Rajesh Balel > > [email protected] > > Enterprise Hadoop Application Support > > > > > > -----Original Message----- > From: Abhishek Girish [mailto:[email protected]] > Sent: Tuesday, October 27, 2015 11:52 AM > To: [email protected] > Subject: Re: "Insert" statement and number in hive dbname for Drill > > > > 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]<mailto: > [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 > > > > > > >
