SPARK HIVE - Parquet and Snappy format - Table issue

[#1]

I am trying to create a hive table in parquet format with snappy compression. Instead of sqlContext I am using HiveContext to directly save my dataframe results into a table using saveAsTable("<table name>").

I set the format using "hc.setConf('spark.sql.parquet.compression.codec','snappy')"

But the hive table is always created as parquet with gz compression instead of parquet with snappy compression codec. Is there any solution for this?

[#2]

@Mahendiran Palani Samy

Try with .option instead of hc.setConf

Example:

dataframe.write()
.format("parquet")
.option("compression","snappy")
.saveAsTable("<table_name>")

[#3]

Thanks, Shu.. It is working now