Currently unable to handle CUBE, ROLLUP, or GROUPSETS.

Comments

2 comments

  • Alan

    Hi Fenghua,

    You can find all our supported SQL functionality here: Using SQL Sheets: SQL Editor Features

    The error message is correct.  The SQL editor does n't support the CUBE, ROLLUP, or GROUPSETS functionality.

    Keep in mind that when you write a SQL sheet in Datameer, it needs to be converted into Java Hadoop code to be executed on your Hadoop cluster.  Hadoop itself operates on columns, rather than on rows, making certain SQL functionality not possible, such as these operations that create subtotal rows.  

    You will need to create a column that calculates your subtotals either with SQL or with a Workbook.  If using our workbook functionality you can use the GROUPSUM feature to create sums for each GROUPBY within a column.

    You can find our list of all workbook functions here: Alphabetical List of Supported Datameer Functions

    Let me know if you have any other questions!

    Sincerely,

    Alan

    0
    Comment actions Permalink
  • Fenghua Zhu

    Thanks! 

    0
    Comment actions Permalink

Please sign in to leave a comment.