Hello Community,
I am currently working on a project where I have to load data to data lake, but I keep getting below error.
[Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query: org.apache.spark.sql.AnalysisException: Unable to infer the schema. The schema specification is required to create the table
Hi @Neha
1-I would start with what the error is saying. Are you passing the schema on your query?
CREATE TABLE schema_name.table_name ( column1 datatype, column2 datatype, ... );
2-If yes, i would try to follow the solution of this topic: Solved: [Simba][Hardy] (80) Syntax or semantic analysis er... - Alteryx Community
Hello @Felipe_Ribeir0 , I tried both these solutions but doesn't seem to work. I suspect there is something wrong with data that I am passing since the same database.table_name format works everywhere.