Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB