This problem is caused by a limitation in Hive:
- When you issue a SHOW CREATE VIEW, it refuses to support external storage handlers.
- In Hive you can only do a SHOW CREATE TABLE - but then you see the resulting (optionally joined) table.
- To see the definition you have to use the ODAS CLI, using the commands below for returning the expected result:
$ odb dataset hive-ddl "show create table testdb.sampleview"
Result: ['CREATE VIEW testdb.sampleview AS\nSELECT sample.record FROM okera_sample.sample']