https://community.cloudera.com/t5/Support-Questions/SPARK-Dataframe-and-IMPALA-CREATE-TABLE-issue/m-p/55834#M22623 <P>Thanks for the reply, The peace of code is mentioned below.</P><P>&nbsp;</P><P>DataFrame right = sqlContext.read().jdbc(DB_CONNECTION, "testDB.tab2", props);<BR />DataFrame joined = sqlContext.read().jdbc(DB_CONNECTION, "testDB.tab1", props).join(right, "id");<BR />joined.write().jdbc(DB_CONNECTION, DB_TABLE3, props);</P><P>&nbsp;</P><P>Its default file comma delimited format. Please find the full exception is mentioned below.&nbsp;</P><P><BR />Exception in thread "main" java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Syntax error in line 1:<BR />....tab3 (id INTEGER , col_1 TEXT , col_2 DOUBLE PRECISIO...<BR />^<BR />Encountered: IDENTIFIER<BR />Expected: ARRAY, BIGINT, BINARY, BOOLEAN, CHAR, DATE, DATETIME, DECIMAL, REAL, FLOAT, INTEGER, MAP, SMALLINT, STRING, STRUCT, TIMESTAMP, TINYINT, VARCHAR</P><P>CAUSED BY: Exception: Syntax error<BR />), Query: CREATE TABLE testDB.tab3 (id INTEGER , col_1 TEXT , col_2 DOUBLE PRECISION , col_3 TIMESTAMP , col_11 TEXT , col_22 DOUBLE PRECISION , col_33 TIMESTAMP ).<BR />at com.cloudera.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source)<BR />at com.cloudera.hivecommon.api.HS2Client.executeStatement(Unknown Source)<BR />at com.cloudera.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeHelper(Unknown Source)<BR />at com.cloudera.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.execute(Unknown Source)<BR />at com.cloudera.jdbc.common.SStatement.executeNoParams(Unknown Source)<BR />at com.cloudera.jdbc.common.SStatement.executeUpdate(Unknown Source)<BR />at org.apache.spark.sql.DataFrameWriter.jdbc(DataFrameWriter.scala:302)<BR />Caused by: com.cloudera.support.exceptions.GeneralException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Syntax error in line 1:<BR />....tab3 (id INTEGER , col_1 TEXT , col_2 DOUBLE PRECISIO...<BR />^<BR />Encountered: IDENTIFIER<BR />Expected: ARRAY, BIGINT, BINARY, BOOLEAN, CHAR, DATE, DATETIME, DECIMAL, REAL, FLOAT, INTEGER, MAP, SMALLINT, STRING, STRUCT, TIMESTAMP, TINYINT, VARCHAR</P><P>CAUSED BY: Exception: Syntax error<BR />), Query: CREATE TABLE testDB.tab3 (id INTEGER , col_1 TEXT , col_2 DOUBLE PRECISION , col_3 TIMESTAMP , col_11 TEXT , col_22 DOUBLE PRECISION , col_33 TIMESTAMP ).<BR />... 7 more</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 14 Jun 2017 06:33:53 GMT Msdhan 2017-06-14T06:33:53Z