Unfortunately it is the case for now spark-sql> show create table payees; Error in query: Failed to execute SHOW CREATE TABLE against table `accounts`.`payees`, which is created by Hive and uses the following unsupported feature(s) - bucketing;
HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com *Disclaimer:* Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction. On 8 August 2016 at 20:12, manish jaiswal <manishsr...@gmail.com> wrote: > correct its creating delta file in hdfs.but after compaction it merge all > data and create extra directory where all bucketed data present.( i am able > to read data from hive but not from sparksql). >