Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive Query via Hue, Only column headers in downloaded CSV or XSL results, sometimes


Copy link to this message
-
Re: Hive Query via Hue, Only column headers in downloaded CSV or XSL results, sometimes
+ hue-user <[EMAIL PROTECTED]>

thanks
Prasad

On Mon, Sep 30, 2013 at 11:05 AM, Martin, Nick <[EMAIL PROTECTED]> wrote:

> Mark - is the Hive table you're using for this fairly wide? If so, are you
> doing a "select * from table_name limit 10"?
>
> We ran some tests this morning on one of the Hive tables giving us some
> fits and if we limit the select to ~20 columns and put the limit on the
> query we get the returns fairly quickly and are able to export.
>
> -----Original Message-----
> From: Sunderlin, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 30, 2013 9:38 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Hive Query via Hue, Only column headers in downloaded CSV or
> XSL results, sometimes
>
> Hmm.. No replies on this one?  Is no one use Hue? :-)  That would be
> interesting to know .. if not Hue, how are others exposing Hive to "end
> users?" without given them a direct login to a node on the cluster?
>
> ---
> Mark E. Sunderlin
> Data Architect     | AOL NETWORKS BDM
> P: 703-265-6935  | C: 540-327-6222 | AIM: MESunderlin
> 22000 AOL Way,  Dulles, VA  20166
>
>
> -----Original Message-----
> From: Sunderlin, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 18, 2013 2:08 PM
> To: [EMAIL PROTECTED]
> Subject: Hive Query via Hue, Only column headers in downloaded CSV or XSL
> results, sometimes
>
> Using Hive V11, via Hue from CDH4, I can run my query, output 10 rows
> (limit 10) and download to a nice CSV or XSL file ... sometimes. :-(
>
> Sometimes, even when the run is error free, the download only downloads
> the column headers.  This is true for both the CSV and XSL options.
>
> It is only ten lines of output, so it cannot be a number of rows issue.
>  Is there a limit to the width of the data you can download?  A limit on
> the number of columns?
>
> Anyone seen this before?  Does anyone  know a fix or a work around?
>
> ---
> Mark E. Sunderlin
> Data Architect     | AOL NETWORKS BDM
> P: 703-265-6935 | C: 540-327-6222 | AIM: MESunderlin
> 22000 AOL Way,  Dulles, VA  20166
>
>
>