Hive Stored As Option

I am looking for Stored As option to support AVRO format. We are using ER 17.0.2(Build 10207) and do not find AVRO in the options. So is there any way to add AVRO into that drop down list ? Is there a possibility to create a macro to generate DDL and update it ? what options do I have if I want to avoid editing the DDL manually after generating script.

No Data
  • This is being looked at for a future release.  The only option right now would be to put it in the Post SQL tab and that should get it to work.  When you generate a database script, you may need to go to the General Options and remove the delimiter to have the script look correct.