PREHOOK: query: CREATE TEMPORARY FUNCTION dboutput AS 'org.apache.hadoop.hive.contrib.genericudf.example.GenericUDFDBOutput' PREHOOK: type: CREATEFUNCTION POSTHOOK: query: CREATE TEMPORARY FUNCTION dboutput AS 'org.apache.hadoop.hive.contrib.genericudf.example.GenericUDFDBOutput' POSTHOOK: type: CREATEFUNCTION PREHOOK: query: DESCRIBE FUNCTION dboutput PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION dboutput POSTHOOK: type: DESCFUNCTION dboutput(jdbcstring,username,password,preparedstatement,[arguments]) - sends data to a jdbc driver PREHOOK: query: DESCRIBE FUNCTION EXTENDED dboutput PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED dboutput POSTHOOK: type: DESCFUNCTION dboutput(jdbcstring,username,password,preparedstatement,[arguments]) - sends data to a jdbc driver argument 0 is the JDBC connection string argument 1 is the user name argument 2 is the password argument 3 is an SQL query to be used in the PreparedStatement argument (4-n) The remaining arguments must be primitive and are passed to the PreparedStatement object PREHOOK: query: EXPLAIN FROM src SELECT dboutput ( 'jdbc:derby:../build/test_dboutput_db;create=true','','', 'CREATE TABLE app_info ( kkey VARCHAR(255) NOT NULL, vvalue VARCHAR(255) NOT NULL, UNIQUE(kkey))' ), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','a'), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','b') limit 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN FROM src SELECT dboutput ( 'jdbc:derby:../build/test_dboutput_db;create=true','','', 'CREATE TABLE app_info ( kkey VARCHAR(255) NOT NULL, vvalue VARCHAR(255) NOT NULL, UNIQUE(kkey))' ), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','a'), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','b') limit 1 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION dboutput 'jdbc:derby:../build/test_dboutput_db;create=true' '' '' 'CREATE TABLE app_info ( kkey VARCHAR(255) NOT NULL, vvalue VARCHAR(255) NOT NULL, UNIQUE(kkey))')) (TOK_SELEXPR (TOK_FUNCTION dboutput 'jdbc:derby:../build/test_dboutput_db' '' '' 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)' '20' 'a')) (TOK_SELEXPR (TOK_FUNCTION dboutput 'jdbc:derby:../build/test_dboutput_db' '' '' 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)' '20' 'b'))) (TOK_LIMIT 1))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: src TableScan alias: src Select Operator expressions: expr: dboutput('jdbc:derby:../build/test_dboutput_db;create=true','','','CREATE TABLE app_info ( kkey VARCHAR(255) NOT NULL, vvalue VARCHAR(255) NOT NULL, UNIQUE(kkey))') type: int expr: dboutput('jdbc:derby:../build/test_dboutput_db','','','INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','a') type: int expr: dboutput('jdbc:derby:../build/test_dboutput_db','','','INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','b') type: int outputColumnNames: _col0, _col1, _col2 Limit File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: 1 PREHOOK: query: FROM src SELECT dboutput ( 'jdbc:derby:../build/test_dboutput_db;create=true','','', 'CREATE TABLE app_info ( kkey INTEGER NOT NULL, vvalue VARCHAR(255) NOT NULL, UNIQUE(kkey))' ), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','a'), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','b') limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/109195708/10000 POSTHOOK: query: FROM src SELECT dboutput ( 'jdbc:derby:../build/test_dboutput_db;create=true','','', 'CREATE TABLE app_info ( kkey INTEGER NOT NULL, vvalue VARCHAR(255) NOT NULL, UNIQUE(kkey))' ), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','a'), dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)','20','b') limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/109195708/10000 0 0 1 PREHOOK: query: EXPLAIN SELECT dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value) FROM src WHERE key < 10 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value) FROM src WHERE key < 10 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION dboutput 'jdbc:derby:../build/test_dboutput_db' '' '' 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)' (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value)))) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 10)))) STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Alias -> Map Operator Tree: src TableScan alias: src Filter Operator predicate: expr: (key < 10) type: boolean Filter Operator predicate: expr: (key < 10) type: boolean Select Operator expressions: expr: dboutput('jdbc:derby:../build/test_dboutput_db','','','INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value) type: int outputColumnNames: _col0 File Output Operator compressed: false GlobalTableId: 0 table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Stage: Stage-0 Fetch Operator limit: -1 PREHOOK: query: SELECT dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value) FROM src WHERE key < 10 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/667407949/10000 POSTHOOK: query: SELECT dboutput('jdbc:derby:../build/test_dboutput_db','','', 'INSERT INTO app_info (kkey,vvalue) VALUES (?,?)',key,value) FROM src WHERE key < 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/667407949/10000 0 0 0 1 1 0 1 0 1 0 Deleted file:/data/users/njain/hive5/hive5/build/test_dboutput_db Deleted file:/data/users/njain/hive5/hive5/contrib/derby.log PREHOOK: query: DROP TEMPORARY FUNCTION dboutput PREHOOK: type: DROPFUNCTION POSTHOOK: query: DROP TEMPORARY FUNCTION dboutput POSTHOOK: type: DROPFUNCTION