You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by he...@apache.org on 2010/08/18 00:33:46 UTC
svn commit: r986512 [8/9] - in /hadoop/hive/trunk: ./
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/queries/clientnegative/ ql/src/test/queries/clientpositive/
ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out Tue Aug 17 22:33:43 2010
@@ -12,6 +12,8 @@ b int
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a STRING
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a a STRING
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
@@ -25,6 +27,8 @@ b int
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
@@ -38,6 +42,8 @@ b int
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT FIRST
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
@@ -51,6 +57,8 @@ b int
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a2 a INT AFTER b
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
@@ -64,6 +72,8 @@ a int
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1'
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a a1 INT COMMENT 'test comment1'
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
@@ -77,6 +87,8 @@ a1 int test comment1
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE a1 a2 INT COMMENT 'test comment2' FIRST
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
@@ -90,6 +102,8 @@ b int
c int
PREHOOK: query: ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b
PREHOOK: type: ALTERTABLE_RENAMECOL
+PREHOOK: Input: default@kv_rename_test
+PREHOOK: Output: default@kv_rename_test
POSTHOOK: query: ALTER TABLE kv_rename_test CHANGE COLUMN a2 a INT AFTER b
POSTHOOK: type: ALTERTABLE_RENAMECOL
POSTHOOK: Input: default@kv_rename_test
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/touch.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/touch.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/touch.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/touch.q.out Tue Aug 17 22:33:43 2010
@@ -1,18 +1,105 @@
-PREHOOK: query: ALTER TABLE src TOUCH
+PREHOOK: query: drop table tstsrc
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tstsrc
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: drop table tstsrcpart
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table tstsrcpart
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table tstsrc like src
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tstsrc like src
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tstsrc
+PREHOOK: query: insert overwrite table tstsrc select key, value from src
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@tstsrc
+POSTHOOK: query: insert overwrite table tstsrc select key, value from src
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@tstsrc
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table tstsrcpart like srcpart
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@tstsrcpart
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from srcpart where ds='2008-04-08' and hr='12'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from srcpart where ds='2008-04-08' and hr='12'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: ALTER TABLE tstsrc TOUCH
PREHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: query: ALTER TABLE src TOUCH
+PREHOOK: Input: default@tstsrc
+PREHOOK: Output: default@tstsrc
+POSTHOOK: query: ALTER TABLE tstsrc TOUCH
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@src
-PREHOOK: query: ALTER TABLE srcpart TOUCH
+POSTHOOK: Input: default@tstsrc
+POSTHOOK: Output: default@tstsrc
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: ALTER TABLE tstsrcpart TOUCH
PREHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: query: ALTER TABLE srcpart TOUCH
+PREHOOK: Input: default@tstsrcpart
+PREHOOK: Output: default@tstsrcpart
+POSTHOOK: query: ALTER TABLE tstsrcpart TOUCH
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@srcpart
-POSTHOOK: Output: default@srcpart
-PREHOOK: query: ALTER TABLE srcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
+POSTHOOK: Input: default@tstsrcpart
+POSTHOOK: Output: default@tstsrcpart
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
PREHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: query: ALTER TABLE srcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
+PREHOOK: Input: default@tstsrcpart
+PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: default@srcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: default@tstsrcpart
+POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: drop table tstsrc
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tstsrc
+PREHOOK: Output: default@tstsrc
+POSTHOOK: query: drop table tstsrc
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tstsrc
+POSTHOOK: Output: default@tstsrc
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+PREHOOK: query: drop table tstsrcpart
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@tstsrcpart
+PREHOOK: Output: default@tstsrcpart
+POSTHOOK: query: drop table tstsrcpart
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@tstsrcpart
+POSTHOOK: Output: default@tstsrcpart
+POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_pop.q.out Tue Aug 17 22:33:43 2010
@@ -36,38 +36,38 @@ where neither x nor y is null.
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-32-57_079_1117526904113027917/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-35_725_9220435062879687360/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-32-57_079_1117526904113027917/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-35_725_9220435062879687360/-mr-10000
NULL
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-00_492_6431652878883191819/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-39_060_5804491211864153160/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a < 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-00_492_6431652878883191819/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-39_060_5804491211864153160/-mr-10000
NULL
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-03_895_3704658650575135394/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-43_110_8178433514900125768/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab WHERE a = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-03_895_3704658650575135394/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-43_110_8178433514900125768/-mr-10000
0.0
PREHOOK: query: SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-06_957_9138283116312967779/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-46_833_2681562938221634943/-mr-10000
POSTHOOK: query: SELECT a, covar_pop(b, c) FROM covar_tab GROUP BY a ORDER BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-06_957_9138283116312967779/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-46_833_2681562938221634943/-mr-10000
1 NULL
2 NULL
3 0.0
@@ -77,14 +77,17 @@ POSTHOOK: Output: file:/tmp/hadoop/hive_
PREHOOK: query: SELECT covar_pop(b, c) FROM covar_tab
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-12_804_1964811148333306251/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-54_062_1334234285764687063/-mr-10000
POSTHOOK: query: SELECT covar_pop(b, c) FROM covar_tab
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-33-12_804_1964811148333306251/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-54_062_1334234285764687063/-mr-10000
3.624999999999999
PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@covar_tab
+PREHOOK: Output: default@covar_tab
POSTHOOK: query: DROP TABLE covar_tab
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: default@covar_tab
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_covar_samp.q.out Tue Aug 17 22:33:43 2010
@@ -36,38 +36,38 @@ where neither x nor y is null.
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 1
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-34-57_138_3229670210627723371/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-59_096_7271177916507722521/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-34-57_138_3229670210627723371/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-00-59_096_7271177916507722521/-mr-10000
NULL
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-00_608_8390642785069332434/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-03_150_1003473188528906420/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a < 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-00_608_8390642785069332434/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-03_150_1003473188528906420/-mr-10000
NULL
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a = 3
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-04_028_8390943423795233918/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-06_694_3640563402690561692/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab WHERE a = 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-04_028_8390943423795233918/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-06_694_3640563402690561692/-mr-10000
0.0
PREHOOK: query: SELECT a, covar_samp(b, c) FROM covar_tab GROUP BY a ORDER BY a
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-07_002_4813467946285728110/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-11_096_5525901401424019584/-mr-10000
POSTHOOK: query: SELECT a, covar_samp(b, c) FROM covar_tab GROUP BY a ORDER BY a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-07_002_4813467946285728110/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-11_096_5525901401424019584/-mr-10000
1 NULL
2 NULL
3 0.0
@@ -77,14 +77,17 @@ POSTHOOK: Output: file:/tmp/hadoop/hive_
PREHOOK: query: SELECT covar_samp(b, c) FROM covar_tab
PREHOOK: type: QUERY
PREHOOK: Input: default@covar_tab
-PREHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-13_103_2218406934546016491/-mr-10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-17_685_5481614396851397426/-mr-10000
POSTHOOK: query: SELECT covar_samp(b, c) FROM covar_tab
POSTHOOK: type: QUERY
POSTHOOK: Input: default@covar_tab
-POSTHOOK: Output: file:/tmp/hadoop/hive_2010-08-13_13-35-13_103_2218406934546016491/-mr-10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-17_685_5481614396851397426/-mr-10000
4.833333333333332
PREHOOK: query: DROP TABLE covar_tab
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@covar_tab
+PREHOOK: Output: default@covar_tab
POSTHOOK: query: DROP TABLE covar_tab
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@covar_tab
POSTHOOK: Output: default@covar_tab
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_ngrams.q.out Tue Aug 17 22:33:43 2010
@@ -11,50 +11,53 @@ POSTHOOK: Output: default@kafka
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-08-55_855_577317115029406892/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-36_784_2506118442657818755/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 2, 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-08-55_855_577317115029406892/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-36_784_2506118442657818755/-mr-10000
[{"ngram":["that","he"],"estfrequency":9.0},{"ngram":["he","thought"],"estfrequency":9.0},{"ngram":["he","was"],"estfrequency":8.0},{"ngram":["on","his"],"estfrequency":8.0},{"ngram":["so","that"],"estfrequency":6.0},{"ngram":["a","little"],"estfrequency":6.0},{"ngram":["in","his"],"estfrequency":5.0},{"ngram":["on","the"],"estfrequency":5.0},{"ngram":["at","the"],"estfrequency":5.0},{"ngram":["he","had"],"estfrequency":5.0},{"ngram":["all","the"],"estfrequency":5.0},{"ngram":["if","he"],"estfrequency":5.0},{"ngram":["he","could"],"estfrequency":5.0},{"ngram":["have","to"],"estfrequency":5.0},{"ngram":["got","to"],"estfrequency":4.0},{"ngram":["if","i"],"estfrequency":4.0},{"ngram":["to","get"],"estfrequency":4.0},{"ngram":["just","what"],"estfrequency":4.0},{"ngram":["my","parents"],"estfrequency":4.0},{"ngram":["to","feel"],"estfrequency":4.0},{"ngram":["up","on"],"estfrequency":4.0},{"ngram":["as","he"],"estfrequency":4.0},{"ngram":["back","to"],"estfrequency":4.0},{"ngra
m":["to","look"],"estfrequency":4.0},{"ngram":["out","the"],"estfrequency":4.0},{"ngram":["to","the"],"estfrequency":4.0},{"ngram":["at","your"],"estfrequency":4.0},{"ngram":["i'd","have"],"estfrequency":4.0},{"ngram":["his","right"],"estfrequency":4.0},{"ngram":["the","boss"],"estfrequency":4.0},{"ngram":["out","on"],"estfrequency":4.0},{"ngram":["i've","got"],"estfrequency":4.0},{"ngram":["what","i"],"estfrequency":4.0},{"ngram":["it","was"],"estfrequency":4.0},{"ngram":["when","he"],"estfrequency":4.0},{"ngram":["but","that"],"estfrequency":4.0},{"ngram":["his","head"],"estfrequency":4.0},{"ngram":["towards","the"],"estfrequency":4.0},{"ngram":["about","if"],"estfrequency":3.0},{"ngram":["collection","of"],"estfrequency":3.0},{"ngram":["would","have"],"estfrequency":3.0},{"ngram":["had","never"],"estfrequency":3.0},{"ngram":["would","be"],"estfrequency":3.0},{"ngram":["must","have"],"estfrequency":3.0},{"ngram":["the","time"],"estfrequency":3.0},{"ngram":["long","time"],"
estfrequency":3.0},{"ngram":["could","see"],"estfrequency":3.0},{"ngram":["with","the"],"estfrequency":3.0},{"ngram":["to","make"],"estfrequency":3.0},{"ngram":["of","that"],"estfrequency":3.0},{"ngram":["a","long"],"estfrequency":3.0},{"ngram":["that","it"],"estfrequency":3.0},{"ngram":["have","been"],"estfrequency":3.0},{"ngram":["he","looked"],"estfrequency":3.0},{"ngram":["time","ago"],"estfrequency":3.0},{"ngram":["up","there"],"estfrequency":2.0},{"ngram":["when","you"],"estfrequency":2.0},{"ngram":["unable","to"],"estfrequency":2.0},{"ngram":["worries","about"],"estfrequency":2.0},{"ngram":["salesmen","live"],"estfrequency":2.0},{"ngram":["brown","belly"],"estfrequency":2.0},{"ngram":["the","headboard"],"estfrequency":2.0},{"ngram":["too","small"],"estfrequency":2.0},{"ngram":["career","it"],"estfrequency":2.0},{"ngram":["into","his"],"estfrequency":2.0},{"ngram":["let","him"],"estfrequency":2.0},{"ngram":["are","always"],"estfrequency":2.0},{"ngram":["friendly","with
"],"estfrequency":2.0},{"ngram":["heard","hitting"],"estfrequency":2.0},{"ngram":["him","just"],"estfrequency":2.0},{"ngram":["still","some"],"estfrequency":2.0},{"ngram":["travelling","salesman"],"estfrequency":2.0},{"ngram":["people","all"],"estfrequency":2.0},{"ngram":["hundred","times"],"estfrequency":2.0},{"ngram":["and","it's"],"estfrequency":2.0},{"ngram":["began","to"],"estfrequency":2.0},{"ngram":["boss","i'd"],"estfrequency":2.0},{"ngram":["what","i'll"],"estfrequency":2.0},{"ngram":["close","because"],"estfrequency":2.0},{"ngram":["gone","up"],"estfrequency":2.0},{"ngram":["thought","but"],"estfrequency":2.0},{"ngram":["a","picture"],"estfrequency":2.0},{"ngram":["samsa","woke"],"estfrequency":2.0},{"ngram":["be","heard"],"estfrequency":2.0},{"ngram":["his","eyes"],"estfrequency":2.0},{"ngram":["off","any"],"estfrequency":2.0},{"ngram":["i'll","make"],"estfrequency":2.0},{"ngram":["other","travelling"],"estfrequency":2.0},{"ngram":["lift","his"],"estfrequency":2.0
},{"ngram":["belly","pushed"],"estfrequency":2.0},{"ngram":["quickly","back"],"estfrequency":2.0},{"ngram":["lay","on"],"estfrequency":2.0},{"ngram":["him","another"],"estfrequency":2.0},{"ngram":["but","who"],"estfrequency":2.0},{"ngram":["to","copy"],"estfrequency":2.0},{"ngram":["its","four"],"estfrequency":2.0},{"ngram":["about","i'd"],"estfrequency":2.0},{"ngram":["size","of"],"estfrequency":2.0},{"ngram":["get","to"],"estfrequency":2.0},{"ngram":["there's","the"],"estfrequency":2.0}]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 1, 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-00_807_3672038623494864629/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-41_311_9103137895455689815/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 1, 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-00_807_3672038623494864629/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-41_311_9103137895455689815/-mr-10000
[{"ngram":["he"],"estfrequency":67.0},{"ngram":["the"],"estfrequency":67.0},{"ngram":["to"],"estfrequency":54.0},{"ngram":["a"],"estfrequency":44.0},{"ngram":["and"],"estfrequency":43.0},{"ngram":["his"],"estfrequency":36.0},{"ngram":["of"],"estfrequency":35.0},{"ngram":["that"],"estfrequency":33.0},{"ngram":["it"],"estfrequency":28.0},{"ngram":["was"],"estfrequency":24.0},{"ngram":["have"],"estfrequency":18.0},{"ngram":["i"],"estfrequency":16.0},{"ngram":["up"],"estfrequency":16.0},{"ngram":["with"],"estfrequency":16.0},{"ngram":["at"],"estfrequency":15.0},{"ngram":["on"],"estfrequency":15.0},{"ngram":["in"],"estfrequency":15.0},{"ngram":["out"],"estfrequency":14.0},{"ngram":["there"],"estfrequency":12.0},{"ngram":["what"],"estfrequency":12.0},{"ngram":["all"],"estfrequency":12.0},{"ngram":["him"],"estfrequency":12.0},{"ngram":["back"],"estfrequency":12.0},{"ngram":["would"],"estfrequency":11.0},{"ngram":["get"],"estfrequency":10.0},{"ngram":["as"],"estfrequency":10.0},{"ng
ram":["my"],"estfrequency":10.0},{"ngram":["when"],"estfrequency":10.0},{"ngram":["feel"],"estfrequency":10.0},{"ngram":["about"],"estfrequency":10.0},{"ngram":["thought"],"estfrequency":9.0},{"ngram":["if"],"estfrequency":9.0},{"ngram":["right"],"estfrequency":8.0},{"ngram":["had"],"estfrequency":8.0},{"ngram":["into"],"estfrequency":8.0},{"ngram":["little"],"estfrequency":8.0},{"ngram":["travelling"],"estfrequency":8.0},{"ngram":["but"],"estfrequency":8.0},{"ngram":["time"],"estfrequency":7.0},{"ngram":["could"],"estfrequency":7.0},{"ngram":["be"],"estfrequency":7.0},{"ngram":["from"],"estfrequency":7.0},{"ngram":["train"],"estfrequency":7.0},{"ngram":["go"],"estfrequency":7.0},{"ngram":["so"],"estfrequency":7.0},{"ngram":["boss"],"estfrequency":7.0},{"ngram":["not"],"estfrequency":7.0},{"ngram":["because"],"estfrequency":7.0},{"ngram":["off"],"estfrequency":6.0},{"ngram":["legs"],"estfrequency":6.0},{"ngram":["lay"],"estfrequency":6.0},{"ngram":["i'd"],"estfrequency":6.0}
,{"ngram":["business"],"estfrequency":6.0},{"ngram":["your"],"estfrequency":6.0},{"ngram":["know"],"estfrequency":6.0},{"ngram":["i've"],"estfrequency":6.0},{"ngram":["fur"],"estfrequency":6.0},{"ngram":["gregor"],"estfrequency":6.0},{"ngram":["got"],"estfrequency":6.0},{"ngram":["just"],"estfrequency":6.0},{"ngram":["you"],"estfrequency":6.0},{"ngram":["for"],"estfrequency":6.0},{"ngram":["himself"],"estfrequency":6.0},{"ngram":["sleep"],"estfrequency":5.0},{"ngram":["do"],"estfrequency":5.0},{"ngram":["still"],"estfrequency":5.0},{"ngram":["five"],"estfrequency":5.0},{"ngram":["never"],"estfrequency":5.0},{"ngram":["this"],"estfrequency":5.0},{"ngram":["more"],"estfrequency":5.0},{"ngram":["felt"],"estfrequency":5.0},{"ngram":["parents"],"estfrequency":5.0},{"ngram":["make"],"estfrequency":5.0},{"ngram":["been"],"estfrequency":5.0},{"ngram":["look"],"estfrequency":4.0},{"ngram":["morning"],"estfrequency":4.0},{"ngram":["doing"],"estfrequency":4.0},{"ngram":["long"],"estfre
quency":4.0},{"ngram":["where"],"estfrequency":4.0},{"ngram":["itch"],"estfrequency":4.0},{"ngram":["room"],"estfrequency":4.0},{"ngram":["day"],"estfrequency":4.0},{"ngram":["by"],"estfrequency":4.0},{"ngram":["which"],"estfrequency":4.0},{"ngram":["i'll"],"estfrequency":4.0},{"ngram":["see"],"estfrequency":4.0},{"ngram":["samsa"],"estfrequency":4.0},{"ngram":["tried"],"estfrequency":4.0},{"ngram":["who"],"estfrequency":4.0},{"ngram":["sitting"],"estfrequency":4.0},{"ngram":["that's"],"estfrequency":4.0},{"ngram":["think"],"estfrequency":4.0},{"ngram":["me"],"estfrequency":4.0},{"ngram":["is"],"estfrequency":4.0},{"ngram":["found"],"estfrequency":4.0},{"ngram":["always"],"estfrequency":4.0},{"ngram":["desk"],"estfrequency":4.0},{"ngram":["belly"],"estfrequency":4.0},{"ngram":["dull"],"estfrequency":4.0},{"ngram":["than"],"estfrequency":4.0}]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-05_661_5547440857175678543/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-44_655_5299823356958739264/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 3, 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-05_661_5547440857175678543/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-44_655_5299823356958739264/-mr-10000
[{"ngram":["that","he","had"],"estfrequency":4.0},{"ngram":["got","to","get"],"estfrequency":4.0},{"ngram":["so","that","he"],"estfrequency":4.0},{"ngram":["just","what","i"],"estfrequency":4.0},{"ngram":["out","on","the"],"estfrequency":4.0},{"ngram":["up","on","his"],"estfrequency":4.0},{"ngram":["a","long","time"],"estfrequency":3.0},{"ngram":["long","time","ago"],"estfrequency":3.0},{"ngram":["he","could","see"],"estfrequency":3.0},{"ngram":["all","the","time"],"estfrequency":3.0},{"ngram":["dreams","he","found"],"estfrequency":2.0},{"ngram":["with","a","fur"],"estfrequency":2.0},{"ngram":["and","irregular","food"],"estfrequency":2.0},{"ngram":["lots","of","little"],"estfrequency":2.0},{"ngram":["right","and","in"],"estfrequency":2.0},{"ngram":["just","try","that"],"estfrequency":2.0},{"ngram":["time","ago","i'd"],"estfrequency":2.0},{"ngram":["of","rain","could"],"estfrequency":2.0},{"ngram":["shut","his","eyes"],"estfrequency":2.0},{"ngram":["little","he","could"],"est
frequency":2.0},{"ngram":["into","his","former"],"estfrequency":2.0},{"ngram":["showed","a","lady"],"estfrequency":2.0},{"ngram":["effort","than","doing"],"estfrequency":2.0},{"ngram":["stopped","when","he"],"estfrequency":2.0},{"ngram":["look","at","the"],"estfrequency":2.0},{"ngram":["a","nice","gilded"],"estfrequency":2.0},{"ngram":["business","at","home"],"estfrequency":2.0},{"ngram":["out","the","contract"],"estfrequency":2.0},{"ngram":["out","the","window"],"estfrequency":2.0},{"ngram":["day","in","and"],"estfrequency":2.0},{"ngram":["can","all","go"],"estfrequency":2.0},{"ngram":["with","one","of"],"estfrequency":2.0},{"ngram":["hard","he","threw"],"estfrequency":2.0},{"ngram":["his","brown","belly"],"estfrequency":2.0},{"ngram":["he","lifted","his"],"estfrequency":2.0},{"ngram":["many","legs","pitifully"],"estfrequency":2.0},{"ngram":["sat","upright","raising"],"estfrequency":2.0},{"ngram":["itch","up","on"],"estfrequency":2.0},{"ngram":["all","go","to"],"estfrequenc
y":2.0},{"ngram":["i","sleep","a"],"estfrequency":2.0},{"ngram":["of","all","though"],"estfrequency":2.0},{"ngram":["to","be","sitting"],"estfrequency":2.0},{"ngram":["irregular","food","contact"],"estfrequency":2.0},{"ngram":["have","tried","it"],"estfrequency":2.0},{"ngram":["however","hard","he"],"estfrequency":2.0},{"ngram":["are","always","still"],"estfrequency":2.0},{"ngram":["had","recently","cut"],"estfrequency":2.0},{"ngram":["slowly","up","on"],"estfrequency":2.0},{"ngram":["how","about","if"],"estfrequency":2.0},{"ngram":["by","arches","into"],"estfrequency":2.0},{"ngram":["know","what","to"],"estfrequency":2.0},{"ngram":["a","fur","hat"],"estfrequency":2.0},{"ngram":["his","present","state"],"estfrequency":2.0},{"ngram":["career","it","is"],"estfrequency":2.0},{"ngram":["to","get","enough"],"estfrequency":2.0},{"ngram":["gregor","samsa","woke"],"estfrequency":2.0},{"ngram":["upright","raising","a"],"estfrequency":2.0},{"ngram":["god","he","thought"],"estfrequency
":2.0},{"ngram":["to","pay","off"],"estfrequency":2.0},{"ngram":["it's","a","funny"],"estfrequency":2.0},{"ngram":["with","lots","of"],"estfrequency":2.0},{"ngram":["contact","with","different"],"estfrequency":2.0},{"ngram":["desk","talking","down"],"estfrequency":2.0},{"ngram":["hundred","times","shut"],"estfrequency":2.0},{"ngram":["close","because","the"],"estfrequency":2.0},{"ngram":["he","was","overcome"],"estfrequency":2.0},{"ngram":["when","he","tried"],"estfrequency":2.0},{"ngram":["what","i'll","do"],"estfrequency":2.0},{"ngram":["about","if","i"],"estfrequency":2.0},{"ngram":["go","to","hell"],"estfrequency":2.0},{"ngram":["cut","out","of"],"estfrequency":2.0},{"ngram":["lift","his","head"],"estfrequency":2.0},{"ngram":["knows","maybe","that"],"estfrequency":2.0},{"ngram":["instance","whenever","i"],"estfrequency":2.0},{"ngram":["all","though","i've"],"estfrequency":2.0},{"ngram":["one","morning","when"],"estfrequency":2.0},{"ngram":["makes","you","stupid"],"estfre
quency":2.0},{"ngram":["magazine","and","housed"],"estfrequency":2.0},{"ngram":["house","during","the"],"estfrequency":2.0},{"ngram":["do","because","he"],"estfrequency":2.0},{"ngram":["arm","towards","the"],"estfrequency":2.0},{"ngram":["him","another","five"],"estfrequency":2.0},{"ngram":["on","the","table"],"estfrequency":2.0},{"ngram":["he","began","to"],"estfrequency":2.0},{"ngram":["because","the","boss"],"estfrequency":2.0},{"ngram":["my","parents","to"],"estfrequency":2.0},{"ngram":["hung","a","picture"],"estfrequency":2.0},{"ngram":["the","alarm","clock"],"estfrequency":2.0},{"ngram":["think","about","i'd"],"estfrequency":2.0},{"ngram":["he","wouldn't","have"],"estfrequency":2.0},{"ngram":["lower","arm","towards"],"estfrequency":2.0},{"ngram":["top","of","that"],"estfrequency":2.0},{"ngram":["into","a","horrible"],"estfrequency":2.0},{"ngram":["to","just","try"],"estfrequency":2.0},{"ngram":["turned","to","look"],"estfrequency":2.0},{"ngram":["out","with","a"],"estf
requency":2.0},{"ngram":["especially","when","you"],"estfrequency":2.0},{"ngram":["the","big","change"],"estfrequency":2.0},{"ngram":["he","always","rolled"],"estfrequency":2.0},{"ngram":["down","at","your"],"estfrequency":2.0}]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-10_279_7710065688103871347/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-48_988_7661969806545519001/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 4, 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-10_279_7710065688103871347/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-48_988_7661969806545519001/-mr-10000
[{"ngram":["a","long","time","ago"],"estfrequency":3.0},{"ngram":["where","the","itch","was"],"estfrequency":2.0},{"ngram":["pane","which","made","him"],"estfrequency":2.0},{"ngram":["had","never","felt","before"],"estfrequency":2.0},{"ngram":["business","to","be","sitting"],"estfrequency":2.0},{"ngram":["he","thought","but","that"],"estfrequency":2.0},{"ngram":["out","the","window","at"],"estfrequency":2.0},{"ngram":["lower","arm","towards","the"],"estfrequency":2.0},{"ngram":["try","that","with","my"],"estfrequency":2.0},{"ngram":["god","he","thought","what"],"estfrequency":2.0},{"ngram":["hitting","the","pane","which"],"estfrequency":2.0},{"ngram":["my","train","leaves","at"],"estfrequency":2.0},{"ngram":["and","it's","a","funny"],"estfrequency":2.0},{"ngram":["people","all","the","time"],"estfrequency":2.0},{"ngram":["present","state","couldn't","get"],"estfrequency":2.0},{"ngram":["hard","he","threw","himself"],"estfrequency":2.0},{"ngram":["could","lift","his","head"],
"estfrequency":2.0},{"ngram":["he","touched","it","he"],"estfrequency":2.0},{"ngram":["your","own","business","at"],"estfrequency":2.0},{"ngram":["takes","much","more","effort"],"estfrequency":2.0},{"ngram":["to","copy","out","the"],"estfrequency":2.0},{"ngram":["on","his","belly","pushed"],"estfrequency":2.0},{"ngram":["look","at","the","floundering"],"estfrequency":2.0},{"ngram":["you've","got","to","get"],"estfrequency":2.0},{"ngram":["floundering","legs","and","only"],"estfrequency":2.0},{"ngram":["well","there's","still","some"],"estfrequency":2.0},{"ngram":["it","he","was","overcome"],"estfrequency":2.0},{"ngram":["his","armour-like","back","and"],"estfrequency":2.0},{"ngram":["was","a","travelling","salesman"],"estfrequency":2.0},{"ngram":["dreams","he","found","himself"],"estfrequency":2.0},{"ngram":["he","found","himself","transformed"],"estfrequency":2.0},{"ngram":["told","him","just","what"],"estfrequency":2.0},{"ngram":["your","subordinates","from","up"],"estfreq
uency":2.0},{"ngram":["notice","a","long","time"],"estfrequency":2.0},{"ngram":["whenever","i","go","back"],"estfrequency":2.0},{"ngram":["divided","by","arches","into"],"estfrequency":2.0},{"ngram":["drew","it","quickly","back"],"estfrequency":2.0},{"ngram":["magazine","and","housed","in"],"estfrequency":2.0},{"ngram":["parents","debt","to","him"],"estfrequency":2.0},{"ngram":["fur","hat","and","fur"],"estfrequency":2.0},{"ngram":["lift","his","head","better"],"estfrequency":2.0},{"ngram":["to","do","because","he"],"estfrequency":2.0},{"ngram":["one","morning","when","gregor"],"estfrequency":2.0},{"ngram":["then","turned","to","look"],"estfrequency":2.0},{"ngram":["hope","once","i've","got"],"estfrequency":2.0},{"ngram":["touched","it","he","was"],"estfrequency":2.0},{"ngram":["because","the","boss","is"],"estfrequency":2.0},{"ngram":["time","he","thought","it"],"estfrequency":2.0},{"ngram":["himself","transformed","in","his"],"estfrequency":2.0},{"ngram":["a","little","bit
","longer"],"estfrequency":2.0},{"ngram":["itch","was","and","saw"],"estfrequency":2.0},{"ngram":["so","that","he","could"],"estfrequency":2.0},{"ngram":["i'd","get","kicked","out"],"estfrequency":2.0},{"ngram":["little","he","could","see"],"estfrequency":2.0},{"ngram":["have","to","look","at"],"estfrequency":2.0},{"ngram":["some","hope","once","i've"],"estfrequency":2.0},{"ngram":["armour-like","back","and","if"],"estfrequency":2.0},{"ngram":["used","to","sleeping","on"],"estfrequency":2.0},{"ngram":["pitifully","thin","compared","with"],"estfrequency":2.0},{"ngram":["i'll","make","the","big"],"estfrequency":2.0},{"ngram":["guest","house","during","the"],"estfrequency":2.0},{"ngram":["little","too","small","lay"],"estfrequency":2.0},{"ngram":["the","contract","these","gentlemen"],"estfrequency":2.0},{"ngram":["get","into","that","position"],"estfrequency":2.0},{"ngram":["out","with","a","fur"],"estfrequency":2.0},{"ngram":["and","when","he","tried"],"estfrequency":2.0},{"ng
ram":["up","close","because","the"],"estfrequency":2.0},{"ngram":["his","brown","belly","slightly"],"estfrequency":2.0},{"ngram":["sat","upright","raising","a"],"estfrequency":2.0},{"ngram":["on","his","armour-like","back"],"estfrequency":2.0},{"ngram":["about","i'd","have","given"],"estfrequency":2.0},{"ngram":["cover","it","and","seemed"],"estfrequency":2.0},{"ngram":["lay","peacefully","between","its"],"estfrequency":2.0},{"ngram":["him","just","what","i"],"estfrequency":2.0},{"ngram":["to","be","sitting","up"],"estfrequency":2.0},{"ngram":["and","seemed","ready","to"],"estfrequency":2.0},{"ngram":["rain","could","be","heard"],"estfrequency":2.0},{"ngram":["boss","and","told","him"],"estfrequency":2.0},{"ngram":["travelling","worries","about","making"],"estfrequency":2.0},{"ngram":["and","forget","all","this"],"estfrequency":2.0},{"ngram":["time","ago","i'd","have"],"estfrequency":2.0},{"ngram":["given","in","my","notice"],"estfrequency":2.0},{"ngram":["the","itch","was",
"and"],"estfrequency":2.0},{"ngram":["samsa","woke","from","troubled"],"estfrequency":2.0},{"ngram":["the","time","so","that"],"estfrequency":2.0},{"ngram":["something","he","was","unable"],"estfrequency":2.0},{"ngram":["to","just","try","that"],"estfrequency":2.0},{"ngram":["effort","than","doing","your"],"estfrequency":2.0},{"ngram":["shut","his","eyes","so"],"estfrequency":2.0},{"ngram":["up","on","his","belly"],"estfrequency":2.0},{"ngram":["a","picture","that","he"],"estfrequency":2.0},{"ngram":["was","overcome","by","a"],"estfrequency":2.0},{"ngram":["i've","got","to","get"],"estfrequency":2.0},{"ngram":["a","little","he","could"],"estfrequency":2.0},{"ngram":["years","i","suppose","that's"],"estfrequency":2.0},{"ngram":["he","must","have","tried"],"estfrequency":2.0},{"ngram":["be","heard","hitting","the"],"estfrequency":2.0},{"ngram":["lifted","his","head","a"],"estfrequency":2.0},{"ngram":["and","only","stopped","when"],"estfrequency":2.0},{"ngram":["covered","the",
"whole","of"],"estfrequency":2.0}]
PREHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000) FROM kafka
PREHOOK: type: QUERY
PREHOOK: Input: default@kafka
-PREHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-15_154_7676586083527166994/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-53_360_8827314176242943195/-mr-10000
POSTHOOK: query: SELECT ngrams(sentences(lower(contents)), 5, 100, 1000) FROM kafka
POSTHOOK: type: QUERY
POSTHOOK: Input: default@kafka
-POSTHOOK: Output: file:/var/folders/7i/7iCDbWRkGHOcgJgX0zscimPXXts/-Tmp-/mlahiri/hive_2010-07-26_15-09-15_154_7676586083527166994/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-01-53_360_8827314176242943195/-mr-10000
[{"ngram":["to","cover","it","and","seemed"],"estfrequency":2.0},{"ngram":["train","connections","bad","and","irregular"],"estfrequency":2.0},{"ngram":["know","what","to","make","of"],"estfrequency":2.0},{"ngram":["with","the","size","of","the"],"estfrequency":2.0},{"ngram":["between","its","four","familiar","walls"],"estfrequency":2.0},{"ngram":["white","spots","which","he","didn't"],"estfrequency":2.0},{"ngram":["headboard","so","that","he","could"],"estfrequency":2.0},{"ngram":["a","little","bit","longer","and"],"estfrequency":2.0},{"ngram":["he","was","overcome","by","a"],"estfrequency":2.0},{"ngram":["talking","down","at","your","subordinates"],"estfrequency":2.0},{"ngram":["he","always","rolled","back","to"],"estfrequency":2.0},{"ngram":["a","fur","hat","and","fur"],"estfrequency":2.0},{"ngram":["of","textile","samples","lay","spread"],"estfrequency":2.0},{"ngram":["little","too","small","lay","peacefully"],"estfrequency":2.0},{"ngram":["heard","hitting","the","pane","
which"],"estfrequency":2.0},{"ngram":["have","given","in","my","notice"],"estfrequency":2.0},{"ngram":["peacefully","between","its","four","familiar"],"estfrequency":2.0},{"ngram":["it","he","was","overcome","by"],"estfrequency":2.0},{"ngram":["heavy","fur","muff","that","covered"],"estfrequency":2.0},{"ngram":["all","though","i've","got","to"],"estfrequency":2.0},{"ngram":["but","who","knows","maybe","that"],"estfrequency":2.0},{"ngram":["his","brown","belly","slightly","domed"],"estfrequency":2.0},{"ngram":["god","he","thought","what","a"],"estfrequency":2.0},{"ngram":["irregular","food","contact","with","different"],"estfrequency":2.0},{"ngram":["because","he","was","used","to"],"estfrequency":2.0},{"ngram":["his","right","and","in","his"],"estfrequency":2.0},{"ngram":["have","to","look","at","the"],"estfrequency":2.0},{"ngram":["the","table","samsa","was","a"],"estfrequency":2.0},{"ngram":["if","he","lifted","his","head"],"estfrequency":2.0},{"ngram":["however","hard","h
e","threw","himself"],"estfrequency":2.0},{"ngram":["by","arches","into","stiff","sections"],"estfrequency":2.0},{"ngram":["of","travelling","worries","about","making"],"estfrequency":2.0},{"ngram":["money","together","to","pay","off"],"estfrequency":2.0},{"ngram":["belly","slightly","domed","and","divided"],"estfrequency":2.0},{"ngram":["longer","and","forget","all","this"],"estfrequency":2.0},{"ngram":["covered","the","whole","of","her"],"estfrequency":2.0},{"ngram":["well","there's","still","some","hope"],"estfrequency":2.0},{"ngram":["salesman","and","above","it","there"],"estfrequency":2.0},{"ngram":["i","would","let","him","know"],"estfrequency":2.0},{"ngram":["to","do","because","he","was"],"estfrequency":2.0},{"ngram":["made","him","feel","quite","sad"],"estfrequency":2.0},{"ngram":["forget","all","this","nonsense","he"],"estfrequency":2.0},{"ngram":["i","sleep","a","little","bit"],"estfrequency":2.0},{"ngram":["thought","it","makes","you","stupid"],"estfrequency":2.
0},{"ngram":["the","contract","these","gentlemen","are"],"estfrequency":2.0},{"ngram":["from","troubled","dreams","he","found"],"estfrequency":2.0},{"ngram":["sleeping","on","his","right","and"],"estfrequency":2.0},{"ngram":["muff","that","covered","the","whole"],"estfrequency":2.0},{"ngram":["lay","peacefully","between","its","four"],"estfrequency":2.0},{"ngram":["desk","talking","down","at","your"],"estfrequency":2.0},{"ngram":["live","a","life","of","luxury"],"estfrequency":2.0},{"ngram":["in","a","nice","gilded","frame"],"estfrequency":2.0},{"ngram":["these","gentlemen","are","always","still"],"estfrequency":2.0},{"ngram":["getting","up","early","all","the"],"estfrequency":2.0},{"ngram":["a","strenuous","career","it","is"],"estfrequency":2.0},{"ngram":["housed","in","a","nice","gilded"],"estfrequency":2.0},{"ngram":["and","irregular","food","contact","with"],"estfrequency":2.0},{"ngram":["that","covered","the","whole","of"],"estfrequency":2.0},{"ngram":["there's","still"
,"some","hope","once"],"estfrequency":2.0},{"ngram":["brown","belly","slightly","domed","and"],"estfrequency":2.0},{"ngram":["effort","than","doing","your","own"],"estfrequency":2.0},{"ngram":["his","belly","pushed","himself","slowly"],"estfrequency":2.0},{"ngram":["overcome","by","a","cold","shudder"],"estfrequency":2.0},{"ngram":["the","boss","and","told","him"],"estfrequency":2.0},{"ngram":["that","he","had","recently","cut"],"estfrequency":2.0},{"ngram":["he","thought","what","a","strenuous"],"estfrequency":2.0},{"ngram":["your","desk","talking","down","at"],"estfrequency":2.0},{"ngram":["so","that","he","could","lift"],"estfrequency":2.0},{"ngram":["i'd","get","kicked","out","on"],"estfrequency":2.0},{"ngram":["curse","of","travelling","worries","about"],"estfrequency":2.0},{"ngram":["bedding","was","hardly","able","to"],"estfrequency":2.0},{"ngram":["above","it","there","hung","a"],"estfrequency":2.0},{"ngram":["he","thought","it","makes","you"],"estfrequency":2.0},{"n
gram":["of","all","though","i've","got"],"estfrequency":2.0},{"ngram":["all","this","nonsense","he","thought"],"estfrequency":2.0},{"ngram":["and","housed","in","a","nice"],"estfrequency":2.0},{"ngram":["magazine","and","housed","in","a"],"estfrequency":2.0},{"ngram":["human","room","although","a","little"],"estfrequency":2.0},{"ngram":["to","go","right","up","close"],"estfrequency":2.0},{"ngram":["more","effort","than","doing","your"],"estfrequency":2.0},{"ngram":["that","he","had","never","felt"],"estfrequency":2.0},{"ngram":["he","wouldn't","have","to","look"],"estfrequency":2.0},{"ngram":["the","size","of","the","rest"],"estfrequency":2.0},{"ngram":["have","tried","it","a","hundred"],"estfrequency":2.0},{"ngram":["he","had","never","felt","before"],"estfrequency":2.0},{"ngram":["eyes","so","that","he","wouldn't"],"estfrequency":2.0},{"ngram":["morning","when","gregor","samsa","woke"],"estfrequency":2.0},{"ngram":["little","bit","longer","and","forget"],"estfrequency":2.0
},{"ngram":["room","a","proper","human","room"],"estfrequency":2.0},{"ngram":["back","to","the","guest","house"],"estfrequency":2.0},{"ngram":["i","didn't","have","my","parents"],"estfrequency":2.0},{"ngram":["could","lift","his","head","better"],"estfrequency":2.0},{"ngram":["i","go","back","to","the"],"estfrequency":2.0},{"ngram":["can","all","go","to","hell"],"estfrequency":2.0},{"ngram":["which","he","didn't","know","what"],"estfrequency":2.0},{"ngram":["sat","upright","raising","a","heavy"],"estfrequency":2.0},{"ngram":["because","as","soon","as","he"],"estfrequency":2.0},{"ngram":["back","and","if","he","lifted"],"estfrequency":2.0},{"ngram":["and","forget","all","this","nonsense"],"estfrequency":2.0},{"ngram":["what","i","think","tell","him"],"estfrequency":2.0}]
PREHOOK: query: DROP TABLE kafka
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@kafka
+PREHOOK: Output: default@kafka
POSTHOOK: query: DROP TABLE kafka
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@kafka
POSTHOOK: Output: default@kafka
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out Tue Aug 17 22:33:43 2010
@@ -58,7 +58,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-31-41_802_6557956853108160258/10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_01-10-27_059_7966685607632186339/-ext-10000
Stage: Stage-0
Move Operator
@@ -73,7 +73,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-31-41_802_6557956853108160258/10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_01-10-27_059_7966685607632186339/-ext-10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -107,11 +107,11 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-31-44_358_3550153861453553323/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-10-31_009_4942235230791767866/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-31-44_358_3550153861453553323/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-10-31_009_4942235230791767866/-mr-10000
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
7
0
@@ -140,8 +140,11 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
0
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@dest1
+PREHOOK: Output: default@dest1
POSTHOOK: query: DROP TABLE dest1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@dest1
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: -- Test with non-ascii characters.
@@ -197,10 +200,10 @@ STAGE PLANS:
PREHOOK: query: SELECT length(dest1.name) FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-31-44_626_9093591696777142802/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-10-32_655_3800203401337247724/-mr-10000
POSTHOOK: query: SELECT length(dest1.name) FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-31-44_626_9093591696777142802/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-10-32_655_3800203401337247724/-mr-10000
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out Tue Aug 17 22:33:43 2010
@@ -58,7 +58,7 @@ STAGE PLANS:
Move Operator
files:
hdfs directory: true
- destination: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-33-53_988_9126910952478207979/10000
+ destination: pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_01-13-27_562_3323174117488390559/-ext-10000
Stage: Stage-0
Move Operator
@@ -73,7 +73,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_13-33-53_988_9126910952478207979/10002
+ pfile:/data/users/njain/hive_commit2/hive_commit2/build/ql/scratchdir/hive_2010-08-17_01-13-27_562_3323174117488390559/-ext-10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -107,11 +107,11 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-33-56_476_2425632697021785832/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-13-31_656_8313398824338699575/-mr-10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-33-56_476_2425632697021785832/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-13-31_656_8313398824338699575/-mr-10000
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
832_lav
@@ -140,8 +140,11 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@dest1
+PREHOOK: Output: default@dest1
POSTHOOK: query: DROP TABLE dest1
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@dest1
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: -- Test with non-ascii characters
@@ -165,10 +168,10 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
PREHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-33-56_662_1561780003827857387/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-13-33_253_5669120500569846630/-mr-10000
POSTHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-33-56_662_1561780003827857387/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-13-33_253_5669120500569846630/-mr-10000
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sentences.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sentences.q.out?rev=986512&r1=986511&r2=986512&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sentences.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_sentences.q.out Tue Aug 17 22:33:43 2010
@@ -34,11 +34,11 @@ POSTHOOK: Lineage: sent_tmp2.val SCRIPT
PREHOOK: query: SELECT hex(val) FROM sent_tmp2
PREHOOK: type: QUERY
PREHOOK: Input: default@sent_tmp2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-34-24_836_5713772058297109062/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-14-11_515_4137923996878514227/-mr-10000
POSTHOOK: query: SELECT hex(val) FROM sent_tmp2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@sent_tmp2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-34-24_836_5713772058297109062/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-14-11_515_4137923996878514227/-mr-10000
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
48697665
@@ -93,15 +93,21 @@ POSTHOOK: Lineage: sent_tmp2.val SCRIPT
6175746F6D617469717565
PREHOOK: query: DROP TABLE sent_tmp
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@sent_tmp
+PREHOOK: Output: default@sent_tmp
POSTHOOK: query: DROP TABLE sent_tmp
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@sent_tmp
POSTHOOK: Output: default@sent_tmp
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
PREHOOK: query: DROP TABLE sent_tmp2
PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@sent_tmp2
+PREHOOK: Output: default@sent_tmp2
POSTHOOK: query: DROP TABLE sent_tmp2
POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@sent_tmp2
POSTHOOK: Output: default@sent_tmp2
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
@@ -149,11 +155,11 @@ POSTHOOK: Lineage: sent_tmp2.val SCRIPT
PREHOOK: query: SELECT hex(val) FROM sent_tmp2
PREHOOK: type: QUERY
PREHOOK: Input: default@sent_tmp2
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-34-32_599_1161655294457683255/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-14-24_219_4337186937954414417/-mr-10000
POSTHOOK: query: SELECT hex(val) FROM sent_tmp2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@sent_tmp2
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-34-32_599_1161655294457683255/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-14-24_219_4337186937954414417/-mr-10000
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
@@ -192,11 +198,11 @@ C39C6265727365747A756E67
PREHOOK: query: SELECT sentences("Hive is an excellent tool for data querying; and perhaps more versatile than machine translation!! Multiple, ill-formed sentences...confounding punctuation--and yet this UDF still works!!!!") FROM src LIMIT 1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-34-35_087_8096865744921319071/10000
+PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-14-27_435_7157960617048129310/-mr-10000
POSTHOOK: query: SELECT sentences("Hive is an excellent tool for data querying; and perhaps more versatile than machine translation!! Multiple, ill-formed sentences...confounding punctuation--and yet this UDF still works!!!!") FROM src LIMIT 1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_13-34-35_087_8096865744921319071/10000
+POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_01-14-27_435_7157960617048129310/-mr-10000
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]