val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) val result = sqlContext.sql("FROM ps.detail_ufdr_other_17920 SELECT *") result.registerTempTable("DFUO") val sdf=sqlContext.sql("select rat,sum(L4_DW_THROUGHPUT) from DFUO group by rat") sdf.write.mode("overwrite").format("com.databricks.spark.csv").option("delimiter", "|").save("/root/test/other_file/")
sorry, just this information we can't confirm root cause, can you share more error information , you can run Hdfs dfs -get /tmp/logs/username/logs/ task ID (username is the user name for submitting the task) check the error taskID inforamtion
Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
Politically sensitive content
Content concerning pornography, gambling, and drug abuse
Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."