blob: 7f1ab0216945e033de84581e330158a952bee5c5 [file] [log] [blame]
PREHOOK: query: CREATE VIEW testView AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Output: database:default
PREHOOK: Output: default@testView
POSTHOOK: query: CREATE VIEW testView AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@testView
POSTHOOK: Lineage: testview.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
PREHOOK: type: ALTERVIEW_PROPERTIES
PREHOOK: Input: default@testview
PREHOOK: Output: default@testview
POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
POSTHOOK: type: ALTERVIEW_PROPERTIES
POSTHOOK: Input: default@testview
POSTHOOK: Output: default@testview
PREHOOK: query: SHOW TBLPROPERTIES testView
PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testView
POSTHOOK: type: SHOW_TBLPROPERTIES
bucketing_version 2
#### A masked pattern was here ####
propA 100
propB 200
#### A masked pattern was here ####
FAILED: SemanticException [Error 10215]: Please use the following syntax if not sure whether the property existed or not:
ALTER TABLE tableName UNSET TBLPROPERTIES IF EXISTS (key1, key2, ...)
The following property propX does not exist in testview