hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Fiedler (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-7602) INSERT INTO TABLE x select * FROM "#temptable"
Date Mon, 04 Aug 2014 14:13:11 GMT

     [ https://issues.apache.org/jira/browse/HIVE-7602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Lars Fiedler updated HIVE-7602:
-------------------------------

    Affects Version/s:     (was: 0.13.1)
                       0.13.0

> 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.0
>         Environment: HortonWorks ODBC driver on Windows
>            Reporter: Lars Fiedler
>
> 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)

Mime
View raw message