Spark Thrift Server - Skip header when load data from local file

Hi, I want to load data from csv file to Spark table using Spark thrift server. When i load, header(first line) should be ignored. I have used tblproperties("skip.header.line.count"="1") option. But its not working and first line also included. Below is spark sql query i have tried. create

Cached table details

Hi, I have cached some table in Spark Thrift Server. I want to get all cached table information. I can see it in 4040 web ui port. Is there any command or other way to get the cached table details programmatically? Thanks, Kumar