You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2015/09/09 04:20:45 UTC

[jira] [Created] (SPARK-10502) tidy up the exception message text to be less verbose/"User friendly"

N Campbell created SPARK-10502:
----------------------------------

             Summary: tidy up the exception message text to be less verbose/"User friendly"
                 Key: SPARK-10502
                 URL: https://issues.apache.org/jira/browse/SPARK-10502
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.3.1
            Reporter: N Campbell
            Priority: Minor


When a statement is parsed, it would be preferred is the exception text were more aligned with other vendors re indicating the syntax error without the inclusion of the verbose parse tree.


 select tbint.rnum,tbint.cbint, nth_value( tbint.cbint, '4' ) over ( order by tbint.rnum) from certstring.tbint 


Errors:
org.apache.spark.sql.AnalysisException: 
Unsupported language features in query: select tbint.rnum,tbint.cbint, nth_value( tbint.cbint, '4' ) over ( order by tbint.rnum) from certstring.tbint
TOK_QUERY 1, 0,40, 94
  TOK_FROM 1, 36,40, 94
    TOK_TABREF 1, 38,40, 94
      TOK_TABNAME 1, 38,40, 94
        certstring 1, 38,38, 94
        tbint 1, 40,40, 105
  TOK_INSERT 0, -1,34, 0
    TOK_DESTINATION 0, -1,-1, 0
      TOK_DIR 0, -1,-1, 0
        TOK_TMP_FILE 0, -1,-1, 0
    TOK_SELECT 1, 0,34, 12
      TOK_SELEXPR 1, 2,4, 12
        . 1, 2,4, 12
          TOK_TABLE_OR_COL 1, 2,2, 7
            tbint 1, 2,2, 7
          rnum 1, 4,4, 13
      TOK_SELEXPR 1, 6,8, 23
        . 1, 6,8, 23
          TOK_TABLE_OR_COL 1, 6,6, 18
            tbint 1, 6,6, 18
          cbint 1, 8,8, 24
      TOK_SELEXPR 1, 11,34, 31
        TOK_FUNCTION 1, 11,34, 31
          nth_value 1, 11,11, 31
          . 1, 14,16, 47
            TOK_TABLE_OR_COL 1, 14,14, 42
              tbint 1, 14,14, 42
            cbint 1, 16,16, 48
          '4' 1, 19,19, 55
          TOK_WINDOWSPEC 1, 25,34, 82
            TOK_PARTITIONINGSPEC 1, 27,33, 82
              TOK_ORDERBY 1, 27,33, 82
                TOK_TABSORTCOLNAMEASC 1, 31,33, 82
                  . 1, 31,33, 82
                    TOK_TABLE_OR_COL 1, 31,31, 77
                      tbint 1, 31,31, 77
                    rnum 1, 33,33, 83

scala.NotImplementedError: No parse rules for ASTNode type: 882, text: TOK_WINDOWSPEC :
TOK_WINDOWSPEC 1, 25,34, 82
  TOK_PARTITIONINGSPEC 1, 27,33, 82
    TOK_ORDERBY 1, 27,33, 82
      TOK_TABSORTCOLNAMEASC 1, 31,33, 82
        . 1, 31,33, 82
          TOK_TABLE_OR_COL 1, 31,31, 77
            tbint 1, 31,31, 77
          rnum 1, 33,33, 83
" +
         
org.apache.spark.sql.hive.HiveQl$.nodeToExpr(HiveQl.scala:1261)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org