Hi Emil,
If you are referring to getting back result without running map-reduce job,
than I don't believe it's possible, Hive must run map-reduce for the "Order
By" part.
Noam.
On Thu, Aug 20, 2015 at 6:57 PM, Emil Berglind <papasw...@gmail.com> wrote:
> I’m running a Hive query over JDBC in a Java app that I wrote. I want to
> be able to turn off task conversion as I am looking to stream the data
> back. I thought I could do that by using the following JDBC URL:
> jdbc:hive2://192.168.132.128:10000/default?hive.fetch.task.conversion=none.
> My SQL statement has an ORDER BY in it, but other than that it is just a
> straight up “SELECT * FROM <table name>”. The task conversion is still
> occurring, and that causes the job to blow up, because the table has 30+
> million rows in it. I just want to stream the data so I can take advantage
> of the fetch size and read the data in batches.
>
--
This e-mail, as well as any attached document, may contain material which
is confidential and privileged and may include trademark, copyright and
other intellectual property rights that are proprietary to Kenshoo Ltd,
its subsidiaries or affiliates ("Kenshoo"). This e-mail and its
attachments may be read, copied and used only by the addressee for the
purpose(s) for which it was disclosed herein. If you have received it in
error, please destroy the message and any attachment, and contact us
immediately. If you are not the intended recipient, be aware that any
review, reliance, disclosure, copying, distribution or use of the contents
of this message without Kenshoo's express permission is strictly prohibited.
