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) ^^^

GitHub | kjedrzejewski | 3 months ago
  1. 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) ^^^
  2. 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`
  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

      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) ^^^

      at org.apache.spark.sql.execution.SparkSqlAstBuilder$$anonfun$visitCreateTable$1.apply()
    2. Spark Project SQL
      SparkSqlAstBuilder$$anonfun$visitCreateTable$1.apply
      1. org.apache.spark.sql.execution.SparkSqlAstBuilder$$anonfun$visitCreateTable$1.apply(SparkSqlParser.scala:905)
      2. org.apache.spark.sql.execution.SparkSqlAstBuilder$$anonfun$visitCreateTable$1.apply(SparkSqlParser.scala:901)
      2 frames
    3. org.apache.spark
      ParserUtils$.withOrigin
      1. org.apache.spark.sql.catalyst.parser.ParserUtils$.withOrigin(ParserUtils.scala:96)
      1 frame
    4. Spark Project SQL
      SparkSqlAstBuilder.visitCreateTable
      1. org.apache.spark.sql.execution.SparkSqlAstBuilder.visitCreateTable(SparkSqlParser.scala:901)
      2. org.apache.spark.sql.execution.SparkSqlAstBuilder.visitCreateTable(SparkSqlParser.scala:53)
      2 frames
    5. org.apache.spark
      SqlBaseParser$CreateTableContext.accept
      1. org.apache.spark.sql.catalyst.parser.SqlBaseParser$CreateTableContext.accept(SqlBaseParser.java:474)
      1 frame
    6. ANTLR 4 Runtime
      AbstractParseTreeVisitor.visit
      1. org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:42)
      1 frame