Hello everyone:
Im confused on how to alias a column. Using Hive .9.
Im running the below sql to try to query an index table and Im getting the
following error.
SELECT
customer_number
, _bucketname
, _offsets
FROM
default.default__customer_table_idx_customer_table__
;
ERROR [HY000] [MapR][Hardy] (22) Error from ThriftHiveClient: Query returned
non-zero code: 40000, cause: FAILED: ParseException line 4:3 mismatched
input ',' expecting \' near '_bucketname' in character string literal
SELECT Command Failed.
A SELECT * on the table will bring back column _bucketname and _offsets.
This is what I want because those are the columns names.
How can I alias these columns _bucketname and _offesets to bring back their
names without running in to this error? Im assuming you need to use \ to
escape the underscore, but so far Ive not figured out how to do it. :/
Best Regards,
Todd Wilson
Senior Technical Consultant
Coffing Data Warehousing
(513) 292-3158
<http://www.coffingdw.com/> www.CoffingDW.com
********************************
The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of the
addressee. Unauthorized use, disclosure, distribution or copying is strictly
prohibited and may be unlawful. If you have received this communication in
error, please notify the sender immediately at
<mailto:[email protected]> [email protected].
*********************************
From: Tim Bittersohl [mailto:[email protected]]
Sent: Wednesday, February 27, 2013 11:36 AM
To: [email protected]
Subject: Get the job id for a hive query
Hi,
has the Hive client the possibility to give back the job id of the job
created when running a query? I need that for tracking.
Greetings
Tim Bittersohl
Software Engineer
http://www.innoplexia.de/ci/logo/inno_logo_links%20200x80.png
Innoplexia GmbH
Mannheimer Str. 175
69123 Heidelberg
Tel.: +49 (0) 6221 7198033
Fax: +49 (0) 6221 7198034
Web: www.innoplexia.com <http://www.innoplexia.com/>
Sitz: 69123 Heidelberg, Mannheimer Str. 175 - Steuernummer 32494/62606 -
USt. IdNr.: DE 272 871 728 - Geschäftsführer: Christian Schneider, Walery
Strauch, Prof. Dr. Herbert Schuster
<<image001.png>>
