itmap und custom).
SQL Fähigkeiten in v13:
* Select mit inner Join und left – right - full outer Join... te auch die kleinere Tabelle im Join sein!
* Subselect mit Alias und korrelierte Subquieres
* Nur nac... Insert Kommando
INSERT INTO TABLE ora_audit_data
SELECT stack(1
,1,"TestDATA","999999","GPI"
... nto the table:
INSERT INTO TABLE ora_audit_data
SELECT id, message , audit_date, instance_name
FROM e
<code>
.GenericJdbcImportExtractor: Using query: SELECT * FROM SYSTEM.AUD$ WHERE ''TESTER' <= USERID AND ... gpi_hive_tab.sql
</code>
Test:
<code sql>
hive>select count(*),userid from ext_ora_audit_gpi group by u... art-m-00009
</code>
Test mit:
<code sql>
SCOTT>select count(*),userid from "SCOTT"."EXT_ORA_AUDIT_GPI_HIVE" group by userid;
no rows selected
... hmmm
# logfiles kontrolliert
EXT_ORA_AUD