title: How to partial column using GROUP BY CUBE in sql (Error in SQL statement: UnsupportedOperationException:)
body: <p>I would like to use <code>GROUP BY CUBE</code> with some columns. I have tried this way (which I found from many website) but I get the error</p>
  <blockquote>
  <p>Error in SQL statement: UnsupportedOperationException:</p>
  </blockquote>
  <p>Here is the query:</p>
  <pre><code>SELECT a, b, c, SUM(d) AS d
  FROM table
  GROUP BY a, CUBE(b, c)
  </code></pre>
  <p>I'm not sure if I did something wrong or you can suggest other way.</p>
  <p>Thanks in advance.</p>
  <p>I separate 'a' outside cube because I don't want to have null (total) in 'a' column as I think it will help to reduce the time as well.</p>