You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Sunderlin, Mark" <ma...@teamaol.com> on 2013/09/18 20:07:41 UTC
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
Re: Hive Query via Hue, Only column headers in downloaded CSV or XSL
results, sometimes
Posted by Prasad Mujumdar <pr...@cloudera.com>.
+ hue-user <hu...@cloudera.org>
thanks
Prasad
On Mon, Sep 30, 2013 at 11:05 AM, Martin, Nick <Ni...@pssd.com> 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:mark.sunderlin@teamaol.com]
> Sent: Monday, September 30, 2013 9:38 AM
> To: user@hive.apache.org
> 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:mark.sunderlin@teamaol.com]
> Sent: Wednesday, September 18, 2013 2:08 PM
> To: user@hive.apache.org
> 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
>
>
>
RE: Hive Query via Hue, Only column headers in downloaded CSV or
XSL results, sometimes
Posted by "Martin, Nick" <Ni...@pssd.com>.
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:mark.sunderlin@teamaol.com]
Sent: Monday, September 30, 2013 9:38 AM
To: user@hive.apache.org
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:mark.sunderlin@teamaol.com]
Sent: Wednesday, September 18, 2013 2:08 PM
To: user@hive.apache.org
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
RE: Hive Query via Hue, Only column headers in downloaded CSV or
XSL results, sometimes
Posted by "Martin, Nick" <Ni...@pssd.com>.
Hi Mark - we hit this issue as well. We use Hue as the Hive front-end for our users and this is a pretty big roadblock for them.
We're on Hue 2.2 and Hive 11.
If you figure out a fix let me know :)
-----Original Message-----
From: Sunderlin, Mark [mailto:mark.sunderlin@teamaol.com]
Sent: Monday, September 30, 2013 9:38 AM
To: user@hive.apache.org
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:mark.sunderlin@teamaol.com]
Sent: Wednesday, September 18, 2013 2:08 PM
To: user@hive.apache.org
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
RE: Hive Query via Hue, Only column headers in downloaded CSV or
XSL results, sometimes
Posted by "Sunderlin, Mark" <ma...@teamaol.com>.
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:mark.sunderlin@teamaol.com]
Sent: Wednesday, September 18, 2013 2:08 PM
To: user@hive.apache.org
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