I’ve been looking at creating ORC tables in Hadoop(2.2) and have successfully used the DBCREATE_TABLE_OPTS on the table properties within SAS DI Studio(4.9) for registered or permanent tables (options do not stick on work tables registered to Hadoop libraries).   What I’ve not managed to do is find is where I can add details of the type of compression(E.G. Snappy) I’d like to use.   Has anyone had any success in doing this other than pass-through user written code? ... View more