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
>
>
