Generating Spark SQL schema files

Spark SQL can import schema files generated by DataStax Enterprise.

Procedure

Export the schema file using dse client-tool.

dse client-tool --use-server-config spark sql-schema --all > output.sql

Copy the schema to an external Spark node.

scp output.sql user@sparknode1.example.com:

On a Spark node, import the schema using Spark.

spark-sql --jars byos-5.1.jar --properties-file  byos.properties -f  output.sql