Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  2. HUE-2179 [core] SQL App revamp
  3. HUE-2527

[beeswax] XLS downloads with large column/row counts

          Details

          • Type: Sub-task
          • Status: Resolved
          • Priority: Critical
          • Resolution: Fixed
          • Affects Version/s: 3.6.0
          • Fix Version/s: 3.10.0
          • Component/s: con.hive, con.impala
          • Labels:
            None

            Description

            "Download the results in XLS format" fails if the result set has >255 columns:

            File "/opt/cloudera/parcels/CDH-5.1.3-1.cdh5.1.3.p0.12/lib/hue/build/env/lib/python2.6/site-packages/tablib-0.9.11-py2.6.egg/tablib/packages/xlwt/Row.py", line 76, in __adjust_bound_col_idx 
raise ValueError("column index (%r) not an int in range(256)" % arg) 
ValueError: column index (256) not an int in range(256)

            This is a limitation of the XLS format, so we should truncate or error out.

            Rows are truncated at 30000, we should warn about the limit or disable XLS download.

              Attachments

                Issue Links

                blocks

                Improvement - An improvement or enhancement to an existing feature or task. HUE-2696 Download as XLS Feature Should Disable with > 256 Columns

                • Major - Major loss of function.
                • Resolved
                relates to

                Improvement - An improvement or enhancement to an existing feature or task. HUE-2523 [core] Add support for xlsx export

                • Major - Major loss of function.
                • Resolved

                Improvement - An improvement or enhancement to an existing feature or task. HUE-2179 [core] SQL App revamp

                • Blocker - Blocks development and/or testing work, production could not run.
                • Resolved

                Improvement - An improvement or enhancement to an existing feature or task. HUE-2142 [core] Automated scalable download of query results

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                  Activity

                    People

                    • Assignee:
                      romain Romain Rigaux
                      Reporter:
                      bwhite Ben White
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      4 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: