java.sql.SQLException: org.apache.spark.sql.AnalysisException: cannot recognize input near 'TEXT' ',' 'last_name' in column type; line 1 pos

Stack Overflow | JP-SD | 1 year ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Apache Spark dataframe createJDBCTable exception

    Stack Overflow | 1 year ago | JP-SD
    java.sql.SQLException: org.apache.spark.sql.AnalysisException: cannot recognize input near 'TEXT' ',' 'last_name' in column type; line 1 pos
  2. 0

    Unable to execute queries on Hive server 2 through JDBC

    Stack Overflow | 8 months ago | Sourav Ghosh
    java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.MoveTask. org.apache.hadoop.hdfs.client.HdfsAdmin.getEncryptionZoneForPath(Lorg/apache/hadoop/fs/Path;)Lorg/apache/hadoop/hdfs/protocol/EncryptionZone;

    Root Cause Analysis

    1. java.sql.SQLException

      org.apache.spark.sql.AnalysisException: cannot recognize input near 'TEXT' ',' 'last_name' in column type; line 1 pos

      at org.apache.hive.jdbc.HiveStatement.execute()
    2. org.apache.hive
      HivePreparedStatement.executeUpdate
      1. org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)
      2. org.apache.hive.jdbc.HiveStatement.executeUpdate(HiveStatement.java:406)
      3. org.apache.hive.jdbc.HivePreparedStatement.executeUpdate(HivePreparedStatement.java:119)
      3 frames
    3. Spark Project SQL
      DataFrame.insertIntoJDBC
      1. org.apache.spark.sql.DataFrameWriter.jdbc(DataFrameWriter.scala:275)
      2. org.apache.spark.sql.DataFrame.insertIntoJDBC(DataFrame.scala:1629)
      2 frames