[jira] [Created] (HIVE-7602) INSERT INTO TABLE x select * FROM "#temptable"

["Lars Fiedler (JIRA)" <ji...@apache.org>]

Lars Fiedler created HIVE-7602:
----------------------------------

             Summary: INSERT INTO TABLE x select * FROM "#temptable"
                 Key: HIVE-7602
                 URL: https://issues.apache.org/jira/browse/HIVE-7602
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2
    Affects Versions: 0.13.1
         Environment: HortonWorks ODBC driver on Windows
            Reporter: Lars Fiedler
             Fix For: 0.13.1


I'm trying to get data into a table using the Hive ODBC driver.  The reason for doing this is because the client does not have direct access to the filesystem to move a file into the HDFS, or create a load query with a filename because the client can't directly add a file to the server.

First, I'm able to successfully create a temporary table (CREATE TABLE "#temptable" ....) , and then insert data into the temporary table ( INSERT INTO ""#temptable"" ( ...) VALUES ...) .  

However, I then need to move this data into the final table (because the temporary table is only good for that connection / session). So I do a query like this:
INSERT INTO TABLE ... select * FROM "#temptable"
And then I get an error:
ERROR [HY000] [Hortonworks][HiveODBC] (35) Error from Hive: error code: '40000' error message: 'Error while compiling statement: FAILED: ParseException line 1:39 cannot recognize input near '"#temptable"' 'limit' '10' in join source'.


I've been using this document as a basis for my query construction:
http://hortonworks.com/wp-content/uploads/2013/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf



--
This message was sent by Atlassian JIRA
(v6.2#6252)