CREATE EXTERNAL TABLE BDAOFSA_STG.DBUG_LOG_TU (C_PROCESS_ID STRING , C_EVENT STRING , C_PROJECT STRING , L_DATABASE STRING , C_PACKAGE STRING , C_PROCESS STRING , L_MESSAGE STRING , A_VALUE BIGINT , D_DATE_LOG DATE , ORDER_NUM BIGINT ) row format delimited fields terminated by '|'stored as TextFile location '/ data/VYB/OFSABDA/OFSASTG.DBUG_LOG_TGC/' (lokasyonun adı) tblproperties('serialization.null.format'='');