Uploaded image for project: 'Hue'
  1. Hue
  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: app.hive, app.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

            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: