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
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:[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