org.apache.spark.sql.catalyst.parser.ParseException: DataType numeric() is not supported.(line 1, pos 103) == SQL == SELECT `carat`, `cut`, `color`, `clarity`, `depth`, `table`, `price`, `x`, `y`, `z`, CAST(`x` > 4.0 AS NUMERIC) AS `binary` -------------------------------------------------------------------------------------------------------^^^ FROM `diamonds`

GitHub | kevinushey | 6 months ago
  1. 0

    cannot cast columns to `numeric` on creation

    GitHub | 6 months ago | kevinushey
    org.apache.spark.sql.catalyst.parser.ParseException: DataType numeric() is not supported.(line 1, pos 103) == SQL == SELECT `carat`, `cut`, `color`, `clarity`, `depth`, `table`, `price`, `x`, `y`, `z`, CAST(`x` > 4.0 AS NUMERIC) AS `binary` -------------------------------------------------------------------------------------------------------^^^ FROM `diamonds`
  2. 0

    *_join(..., copy = T) doesn't work

    GitHub | 3 months ago | kjedrzejewski
    org.apache.spark.sql.catalyst.parser.ParseException: CREATE TEMPORARY TABLE is not supported yet. Please use CREATE TEMPORARY VIEW as an alternative.(line 1, pos 0) == SQL == CREATE TEMPORARY TABLE `rnprrlqxwk` (`t` INTEGER, `name` STRING) ^^^
  3. 0

    Select not null values in dataframes in Spark

    Stack Overflow | 2 weeks ago | John Doe
    org.apache.spark.sql.catalyst.parser.ParseException: extraneous input '' expecting {'(', 'SELECT', .. == SQL == IncidntNum is not null ^^^
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    spark-sql parse sql insert into error

    Stack Overflow | 3 months ago | SailingYang
    org.apache.spark.sql.catalyst.parser.ParseException: mismatched input 'idx' expecting {'(', 'SELECT', 'FROM', 'VALUES', 'TABLE', 'INSERT', 'MAP', 'REDUCE'}(line 1, pos 31) == SQL == insert into TABLE parquetFile (idx, name, age) values (200, "hello", 78) -------------------------------^^^ at org.apache.spark.sql.catalyst.parser.ParseException.withCommand(ParseDriver.scala:197)

    Root Cause Analysis

    1. org.apache.spark.sql.catalyst.parser.ParseException

      DataType numeric() is not supported.(line 1, pos 103) == SQL == SELECT `carat`, `cut`, `color`, `clarity`, `depth`, `table`, `price`, `x`, `y`, `z`, CAST(`x` > 4.0 AS NUMERIC) AS `binary` -------------------------------------------------------------------------------------------------------^^^ FROM `diamonds`

      at org.apache.spark.sql.catalyst.parser.AstBuilder$$anonfun$visitPrimitiveDataType$1.apply()
    2. org.apache.spark
      SqlBaseParser$PrimitiveDataTypeContext.accept
      1. org.apache.spark.sql.catalyst.parser.AstBuilder$$anonfun$visitPrimitiveDataType$1.apply(AstBuilder.scala:1418)
      2. org.apache.spark.sql.catalyst.parser.AstBuilder$$anonfun$visitPrimitiveDataType$1.apply(AstBuilder.scala:1400)
      3. org.apache.spark.sql.catalyst.parser.ParserUtils$.withOrigin(ParserUtils.scala:89)
      4. org.apache.spark.sql.catalyst.parser.AstBuilder.visitPrimitiveDataType(AstBuilder.scala:1399)
      5. org.apache.spark.sql.catalyst.parser.AstBuilder.visitPrimitiveDataType(AstBuilder.scala:42)
      6. org.apache.spark.sql.catalyst.parser.SqlBaseParser$PrimitiveDataTypeContext.accept(SqlBaseParser.java:11989)
      6 frames