hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r897026 [3/4] - in /hadoop/hive/trunk: ./ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Date Thu, 07 Jan 2010 21:54:39 GMT
Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_dayofmonth.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_dayofmonth.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_dayofmonth.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_dayofmonth.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,15 @@
+PREHOOK: query: DESCRIBE FUNCTION dayofmonth
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION dayofmonth
+POSTHOOK: type: DESCFUNCTION
+dayofmonth(date) - Returns the date of the month of date
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED dayofmonth
+POSTHOOK: type: DESCFUNCTION
+dayofmonth(date) - Returns the date of the month of date
+Synonyms: day
+date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'yyyy-MM-dd'.
+Example:
+   > SELECT dayofmonth('2009-30-07', 1) FROM src LIMIT 1;
+  30

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_div.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_div.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_div.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_div.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,22 @@
+PREHOOK: query: DESCRIBE FUNCTION div
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION div
+POSTHOOK: type: DESCFUNCTION
+a div b - Divide a by b rounded to the long integer
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED div
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED div
+POSTHOOK: type: DESCFUNCTION
+a div b - Divide a by b rounded to the long integer
+Example:
+  > SELECT 3 div 2 FROM src LIMIT 1;
+  1
+PREHOOK: query: SELECT 3 DIV 2 FROM SRC LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1061563438/10000
+POSTHOOK: query: SELECT 3 DIV 2 FROM SRC LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1061563438/10000
+1

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divide.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divide.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divide.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divide.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,22 @@
+PREHOOK: query: DESCRIBE FUNCTION /
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION /
+POSTHOOK: type: DESCFUNCTION
+a / b - Divide a by b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED /
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED /
+POSTHOOK: type: DESCFUNCTION
+a / b - Divide a by b
+Example:
+  > SELECT 3 / 2 FROM src LIMIT 1;
+  1.5
+PREHOOK: query: SELECT 3 / 2 FROM SRC LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1123393035/10000
+POSTHOOK: query: SELECT 3 / 2 FROM SRC LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1123393035/10000
+1.5

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_divider.q.out Thu Jan  7 21:54:33 2010
@@ -1,31 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION div
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION div
-POSTHOOK: type: DESCFUNCTION
-a div b - Divide a by b rounded to the long integer
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED div
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED div
-POSTHOOK: type: DESCFUNCTION
-a div b - Divide a by b rounded to the long integer
-Example:
-  > SELECT 3 div 2 FROM src LIMIT 1;
-  1
-PREHOOK: query: SELECT 3 / 2 FROM SRC LIMIT 1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/173284244/10000
-POSTHOOK: query: SELECT 3 / 2 FROM SRC LIMIT 1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/173284244/10000
-1.5
-PREHOOK: query: SELECT 3 DIV 2 FROM SRC LIMIT 1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1585227313/10000
-POSTHOOK: query: SELECT 3 DIV 2 FROM SRC LIMIT 1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1585227313/10000
-1

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_double.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_double.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_double.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_double.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION double
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION double
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'double'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED double
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED double
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'double'

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_equal.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_equal.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_equal.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_equal.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,22 @@
+PREHOOK: query: DESCRIBE FUNCTION =
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION =
+POSTHOOK: type: DESCFUNCTION
+a = b - Returns TRUE if a equals b and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED =
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED =
+POSTHOOK: type: DESCFUNCTION
+a = b - Returns TRUE if a equals b and false otherwise
+Synonyms: ==
+PREHOOK: query: DESCRIBE FUNCTION ==
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ==
+POSTHOOK: type: DESCFUNCTION
+a == b - Returns TRUE if a equals b and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ==
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ==
+POSTHOOK: type: DESCFUNCTION
+a == b - Returns TRUE if a equals b and false otherwise
+Synonyms: =

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_exp.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_exp.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_exp.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_exp.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION exp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION exp
+POSTHOOK: type: DESCFUNCTION
+exp(x) - Returns e to the power of x
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED exp
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED exp
+POSTHOOK: type: DESCFUNCTION
+exp(x) - Returns e to the power of x
+Example:
+   > SELECT exp(0) FROM src LIMIT 1;
+  1

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_explode.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,298 @@
+PREHOOK: query: DESCRIBE FUNCTION explode
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION explode
+POSTHOOK: type: DESCFUNCTION
+explode(a) - separates the elements of array a into multiple rows 
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED explode
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED explode
+POSTHOOK: type: DESCFUNCTION
+explode(a) - separates the elements of array a into multiple rows 
+PREHOOK: query: EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
+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 explode (TOK_FUNCTION array 1 2 3)) myCol)) (TOK_LIMIT 3)))
+
+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: array(1,2,3)
+                    type: array<int>
+              outputColumnNames: _col0
+              UDTF Operator
+                function name: explode
+                Limit
+                  File Output Operator
+                    compressed: false
+                    GlobalTableId: 0
+                    directory: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/626057626/10001
+                    table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                        properties:
+                          columns col
+                          serialization.format 1
+                          columns.types int
+      Needs Tagging: false
+      Path -> Alias:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src [src]
+      Path -> Partition:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src 
+          Partition
+            base file name: src
+            input format: org.apache.hadoop.mapred.TextInputFormat
+            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+            properties:
+              name src
+              columns.types string:string
+              serialization.ddl struct src { string key, string value}
+              serialization.format 1
+              columns key,value
+              bucket_count -1
+              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              file.inputformat org.apache.hadoop.mapred.TextInputFormat
+              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+              location file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src
+              transient_lastDdlTime 1262858387
+            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+              properties:
+                name src
+                columns.types string:string
+                serialization.ddl struct src { string key, string value}
+                serialization.format 1
+                columns key,value
+                bucket_count -1
+                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                location file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src
+                transient_lastDdlTime 1262858387
+              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              name: src
+            name: src
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: 3
+
+
+PREHOOK: query: EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION explode (TOK_FUNCTION array 1 2 3)) myCol)) (TOK_LIMIT 3))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) myCol)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL a) myCol))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        a:src 
+          TableScan
+            alias: src
+            Select Operator
+              expressions:
+                    expr: array(1,2,3)
+                    type: array<int>
+              outputColumnNames: _col0
+              UDTF Operator
+                function name: explode
+                Limit
+                  Reduce Output Operator
+                    sort order: 
+                    tag: -1
+                    value expressions:
+                          expr: col
+                          type: int
+      Needs Tagging: false
+      Path -> Alias:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src [a:src]
+      Path -> Partition:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src 
+          Partition
+            base file name: src
+            input format: org.apache.hadoop.mapred.TextInputFormat
+            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+            properties:
+              name src
+              columns.types string:string
+              serialization.ddl struct src { string key, string value}
+              serialization.format 1
+              columns key,value
+              bucket_count -1
+              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              file.inputformat org.apache.hadoop.mapred.TextInputFormat
+              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+              location file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src
+              transient_lastDdlTime 1262858387
+            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+              properties:
+                name src
+                columns.types string:string
+                serialization.ddl struct src { string key, string value}
+                serialization.format 1
+                columns key,value
+                bucket_count -1
+                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                location file:/Users/carl/Projects/hd8/hive-trunk/build/ql/test/data/warehouse/src
+                transient_lastDdlTime 1262858387
+              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+              name: src
+            name: src
+      Reduce Operator Tree:
+        Extract
+          Limit
+            Select Operator
+              expressions:
+                    expr: _col0
+                    type: int
+              outputColumnNames: _col0
+              Group By Operator
+                aggregations:
+                      expr: count(1)
+                bucketGroup: false
+                keys:
+                      expr: _col0
+                      type: int
+                mode: hash
+                outputColumnNames: _col0, _col1
+                File Output Operator
+                  compressed: false
+                  GlobalTableId: 0
+                  directory: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1329975374/10002
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      properties:
+                        columns _col0,_col1
+                        columns.types int,bigint
+                        escape.delim \
+
+  Stage: Stage-2
+    Map Reduce
+      Alias -> Map Operator Tree:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1329975374/10002 
+            Reduce Output Operator
+              key expressions:
+                    expr: _col0
+                    type: int
+              sort order: +
+              Map-reduce partition columns:
+                    expr: _col0
+                    type: int
+              tag: -1
+              value expressions:
+                    expr: _col1
+                    type: bigint
+      Needs Tagging: false
+      Path -> Alias:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1329975374/10002 [file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1329975374/10002]
+      Path -> Partition:
+        file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1329975374/10002 
+          Partition
+            base file name: 10002
+            input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+            output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+            properties:
+              columns _col0,_col1
+              columns.types int,bigint
+              escape.delim \
+          
+              input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+              output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+              properties:
+                columns _col0,_col1
+                columns.types int,bigint
+                escape.delim \
+      Reduce Operator Tree:
+        Group By Operator
+          aggregations:
+                expr: count(VALUE._col0)
+          bucketGroup: false
+          keys:
+                expr: KEY._col0
+                type: int
+          mode: mergepartial
+          outputColumnNames: _col0, _col1
+          Select Operator
+            expressions:
+                  expr: _col0
+                  type: int
+                  expr: _col1
+                  type: bigint
+            outputColumnNames: _col0, _col1
+            File Output Operator
+              compressed: false
+              GlobalTableId: 0
+              directory: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1329975374/10001
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  properties:
+                    columns _col0,_col1
+                    serialization.format 1
+                    columns.types int:bigint
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+PREHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/374186866/10000
+POSTHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/374186866/10000
+1
+2
+3
+PREHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/83813908/10000
+POSTHOOK: query: SELECT explode(array(1,2,3)) AS (myCol) FROM src LIMIT 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/83813908/10000
+1
+2
+3
+PREHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1571747562/10000
+POSTHOOK: query: SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1571747562/10000
+1	1
+2	1
+3	1

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_float.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_float.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_float.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_float.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION float
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION float
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'float'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED float
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED float
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'float'

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_floor.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_floor.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_floor.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_floor.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,15 @@
+PREHOOK: query: DESCRIBE FUNCTION floor
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION floor
+POSTHOOK: type: DESCFUNCTION
+floor(x) - Find the largest integer not greater than x
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED floor
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED floor
+POSTHOOK: type: DESCFUNCTION
+floor(x) - Find the largest integer not greater than x
+Example:
+  > SELECT floor(-0.1) FROM src LIMIT 1;
+  -1
+  > SELECT floor(5) FROM src LIMIT 1;
+  5

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_from_unixtime.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_from_unixtime.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_from_unixtime.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_from_unixtime.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION from_unixtime
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION from_unixtime
+POSTHOOK: type: DESCFUNCTION
+from_unixtime(unix_time, format) - returns unix_time in the specified format
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED from_unixtime
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED from_unixtime
+POSTHOOK: type: DESCFUNCTION
+from_unixtime(unix_time, format) - returns unix_time in the specified format
+Example:
+  > SELECT from_unixtime(0, 'yyyy-MM-dd HH:mm:ss') FROM src LIMIT 1;
+  '1970-01-01 00:00:00'

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,147 @@
+PREHOOK: query: DESCRIBE FUNCTION get_json_object
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION get_json_object
+POSTHOOK: type: DESCFUNCTION
+get_json_object(json_txt, path) - Extract a json object from path 
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED get_json_object
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED get_json_object
+POSTHOOK: type: DESCFUNCTION
+get_json_object(json_txt, path) - Extract a json object from path 
+Extract json object from a json string based on json path specified, and return json string of the extracted json object. It will return null if the input json string is invalid.
+A limited version of JSONPath supported:
+  $   : Root object
+  .   : Child operator
+  []  : Subscript operator for array
+  *   : Wildcard for []
+Syntax not supported that's worth noticing:
+  ''  : Zero length string as key
+  ..  : Recursive descent
+  &amp;#064;   : Current object/element
+  ()  : Script expression
+  ?() : Filter (script) expression.
+  [,] : Union operator
+  [start:end:step] : array slice operator
+
+PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@dest1
+PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: default@dest1
+POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: default@dest1
+PREHOOK: query: EXPLAIN
+SELECT get_json_object(src_json.json, '$.owner') FROM src_json
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT get_json_object(src_json.json, '$.owner') FROM src_json
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src_json)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION get_json_object (. (TOK_TABLE_OR_COL src_json) json) '$.owner')))))
+
+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_json 
+          TableScan
+            alias: src_json
+            Select Operator
+              expressions:
+                    expr: get_json_object(json, '$.owner')
+                    type: string
+              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 get_json_object(src_json.json, '$') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1615998931/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1615998931/10000
+{"store":{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"book":[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"bicycle":{"price":19.95,"color":"red"}},"email":"amy@only_for_json_udf_test.net","owner":"amy"}
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/543860321/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/543860321/10000
+amy	{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"book":[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"bicycle":{"price":19.95,"color":"red"}}
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1327255777/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1327255777/10000
+{"price":19.95,"color":"red"}	[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}]
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/563232699/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/563232699/10000
+{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95}	[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}]
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1253200680/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1253200680/10000
+reference	["reference","fiction","fiction"]	["0-553-21311-3","0-395-19395-8"]	[{"name":"bob","age":25},{"name":"jack","age":26}]
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age')  FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1931998473/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age')  FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1931998473/10000
+25	[25,26]
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1551395780/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1551395780/10000
+2	[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]]	1	[1,2,{"b":"y","a":"x"}]	[1,2,{"b":"y","a":"x"},3,4,5,6]	y	["y"]
+PREHOOK: query: SELECT get_json_object(src_json.json, '$.non_exist_key'),  get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src_json
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1199445708/10000
+POSTHOOK: query: SELECT get_json_object(src_json.json, '$.non_exist_key'),  get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src_json
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1199445708/10000
+NULL	NULL	NULL	NULL	NULL	NULL

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthan.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthan.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthan.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthan.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION >
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION >
+POSTHOOK: type: DESCFUNCTION
+a > b - Returns TRUE if a is greater than b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED >
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED >
+POSTHOOK: type: DESCFUNCTION
+a > b - Returns TRUE if a is greater than b

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_greaterthanorequal.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION >=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION >=
+POSTHOOK: type: DESCFUNCTION
+a >= b - Returns TRUE if b is not smaller than a
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED >=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED >=
+POSTHOOK: type: DESCFUNCTION
+a >= b - Returns TRUE if b is not smaller than a

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,78 @@
+PREHOOK: query: DESCRIBE FUNCTION hour
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION hour
+POSTHOOK: type: DESCFUNCTION
+hour(date) - Returns the hour of date
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED hour
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hour
+POSTHOOK: type: DESCFUNCTION
+hour(date) - Returns the hour of date
+date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
+Example:
+   > SELECT hour('2009-07-30 12:58:59') FROM src LIMIT 1;
+  12
+  > SELECT hour('12:58:59') FROM src LIMIT 1;
+  12
+PREHOOK: query: EXPLAIN
+SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN
+SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
+FROM src WHERE key = 86
+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 hour '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
+
+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 = 86)
+                  type: boolean
+              Filter Operator
+                predicate:
+                    expr: (key = 86)
+                    type: boolean
+                Select Operator
+                  expressions:
+                        expr: hour('2009-08-07 13:14:15')
+                        type: int
+                        expr: hour('13:14:15')
+                        type: int
+                        expr: hour('2009-08-07')
+                        type: int
+                  outputColumnNames: _col0, _col1, _col2
+                  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 hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
+FROM src WHERE key = 86
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1371344681/10000
+POSTHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07')
+FROM src WHERE key = 86
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1371344681/10000
+13	13	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_hour_minute_second.q.out Thu Jan  7 21:54:33 2010
@@ -1,130 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION hour
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION hour
-POSTHOOK: type: DESCFUNCTION
-hour(date) - Returns the hour of date
-PREHOOK: query: DESCRIBE FUNCTION minute
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION minute
-POSTHOOK: type: DESCFUNCTION
-minute(date) - Returns the minute of date
-PREHOOK: query: DESCRIBE FUNCTION second
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION second
-POSTHOOK: type: DESCFUNCTION
-second(date) - Returns the second of date
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED hour
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED hour
-POSTHOOK: type: DESCFUNCTION
-hour(date) - Returns the hour of date
-date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
-Example:
-   > SELECT hour('2009-07-30 12:58:59') FROM src LIMIT 1;
-  12
-  > SELECT hour('12:58:59') FROM src LIMIT 1;
-  12
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED minute
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED minute
-POSTHOOK: type: DESCFUNCTION
-minute(date) - Returns the minute of date
-date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
-Example:
-   > SELECT minute('2009-07-30 12:58:59') FROM src LIMIT 1;
-  58
-  > SELECT minute('12:58:59') FROM src LIMIT 1;
-  58
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED second
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED second
-POSTHOOK: type: DESCFUNCTION
-second(date) - Returns the second of date
-date is a string in the format of 'yyyy-MM-dd HH:mm:ss' or 'HH:mm:ss'.
-Example:
-   > SELECT second('2009-07-30 12:58:59') FROM src LIMIT 1;
-  59
-  > SELECT second('12:58:59') FROM src LIMIT 1;
-  59
-PREHOOK: query: EXPLAIN
-SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
-       minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
-       second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
-FROM src WHERE key = 86
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
-SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
-       minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
-       second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
-FROM src WHERE key = 86
-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 hour '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION hour '2009-08-07')) (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION minute '2009-08-07')) (TOK_SELEXPR (TOK_FUNCTION second '2009-08-07 13:14:15')) (TOK_SELEXPR (TOK_FUNCTION second '13:14:15')) (TOK_SELEXPR (TOK_FUNCTION second '2009-08-07'))) (TOK_WHERE (= (TOK_TABLE_OR_COL key) 86))))
-
-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 = 86)
-                  type: boolean
-              Filter Operator
-                predicate:
-                    expr: (key = 86)
-                    type: boolean
-                Select Operator
-                  expressions:
-                        expr: hour('2009-08-07 13:14:15')
-                        type: int
-                        expr: hour('13:14:15')
-                        type: int
-                        expr: hour('2009-08-07')
-                        type: int
-                        expr: minute('2009-08-07 13:14:15')
-                        type: int
-                        expr: minute('13:14:15')
-                        type: int
-                        expr: minute('2009-08-07')
-                        type: int
-                        expr: second('2009-08-07 13:14:15')
-                        type: int
-                        expr: second('13:14:15')
-                        type: int
-                        expr: second('2009-08-07')
-                        type: int
-                  outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
-                  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 hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
-       minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
-       second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
-FROM src WHERE key = 86
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/785767007/10000
-POSTHOOK: query: SELECT hour('2009-08-07 13:14:15'), hour('13:14:15'), hour('2009-08-07'),
-       minute('2009-08-07 13:14:15'), minute('13:14:15'), minute('2009-08-07'),
-       second('2009-08-07 13:14:15'), second('13:14:15'), second('2009-08-07')
-FROM src WHERE key = 86
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/785767007/10000
-13	13	NULL	14	14	NULL	15	15	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out Thu Jan  7 21:54:33 2010
@@ -2,12 +2,12 @@
 PREHOOK: type: DESCFUNCTION
 POSTHOOK: query: DESCRIBE FUNCTION if
 POSTHOOK: type: DESCFUNCTION
-There is no documentation for function if
+There is no documentation for function 'if'
 PREHOOK: query: DESCRIBE FUNCTION EXTENDED if
 PREHOOK: type: DESCFUNCTION
 POSTHOOK: query: DESCRIBE FUNCTION EXTENDED if
 POSTHOOK: type: DESCFUNCTION
-There is no documentation for function if
+There is no documentation for function 'if'
 PREHOOK: query: EXPLAIN
 SELECT IF(TRUE, 1, 2) AS COL1,
        IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
@@ -77,7 +77,7 @@
 FROM src LIMIT 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1635207375/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1694401467/10000
 POSTHOOK: query: SELECT IF(TRUE, 1, 2) AS COL1,
        IF(FALSE, CAST(NULL AS STRING), CAST(1 AS STRING)) AS COL2,
        IF(1=1, IF(2=2, 1, 2), IF(3=3, 3, 4)) AS COL3,
@@ -87,7 +87,7 @@
 FROM src LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1635207375/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1694401467/10000
 1	1	1	1	NULL	2
 PREHOOK: query: -- Type conversions
 EXPLAIN
@@ -150,7 +150,7 @@
 FROM src LIMIT 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1478265880/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/984666042/10000
 POSTHOOK: query: SELECT IF(TRUE, CAST(128 AS SMALLINT), CAST(1 AS TINYINT)) AS COL1,
        IF(FALSE, 1, 1.1) AS COL2,
        IF(FALSE, 1, 'ABC') AS COL3,
@@ -158,5 +158,5 @@
 FROM src LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1478265880/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/984666042/10000
 128	1.1	ABC	12.3

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_index.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_index.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_index.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_index.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION index
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION index
+POSTHOOK: type: DESCFUNCTION
+index(a, n) - Returns the n-th element of a 
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED index
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED index
+POSTHOOK: type: DESCFUNCTION
+index(a, n) - Returns the n-th element of a 

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_int.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_int.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_int.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_int.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION int
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION int
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'int'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED int
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED int
+POSTHOOK: type: DESCFUNCTION
+There is no documentation for function 'int'

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnotnull.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnotnull.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnotnull.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnotnull.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION isnotnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION isnotnull
+POSTHOOK: type: DESCFUNCTION
+isnotnull a - Returns true if a is not NULL and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull
+POSTHOOK: type: DESCFUNCTION
+isnotnull a - Returns true if a is not NULL and false otherwise

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_isnull.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION isnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION isnull
+POSTHOOK: type: DESCFUNCTION
+isnull a - Returns true if a is NULL and false otherwise
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED isnull
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnull
+POSTHOOK: type: DESCFUNCTION
+isnull a - Returns true if a is NULL and false otherwise

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_json.q.out Thu Jan  7 21:54:33 2010
@@ -1,147 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION get_json_object
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION get_json_object
-POSTHOOK: type: DESCFUNCTION
-get_json_object(json_txt, path) - Extract a json object from path 
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED get_json_object
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED get_json_object
-POSTHOOK: type: DESCFUNCTION
-get_json_object(json_txt, path) - Extract a json object from path 
-Extract json object from a json string based on json path specified, and return json string of the extracted json object. It will return null if the input json string is invalid.
-A limited version of JSONPath supported:
-  $   : Root object
-  .   : Child operator
-  []  : Subscript operator for array
-  *   : Wildcard for []
-Syntax not supported that's worth noticing:
-  ''  : Zero length string as key
-  ..  : Recursive descent
-  &amp;#064;   : Current object/element
-  ()  : Script expression
-  ?() : Filter (script) expression.
-  [,] : Union operator
-  [start:end:step] : array slice operator
-
-PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: default@dest1
-PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: default@dest1
-POSTHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '  abc  ' WHERE src.key = 86
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: default@dest1
-PREHOOK: query: EXPLAIN
-SELECT get_json_object(src_json.json, '$.owner') FROM src_json
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
-SELECT get_json_object(src_json.json, '$.owner') FROM src_json
-POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src_json)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION get_json_object (. (TOK_TABLE_OR_COL src_json) json) '$.owner')))))
-
-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_json 
-          TableScan
-            alias: src_json
-            Select Operator
-              expressions:
-                    expr: get_json_object(json, '$.owner')
-                    type: string
-              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 get_json_object(src_json.json, '$') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/483712443/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/483712443/10000
-{"store":{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"book":[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"bicycle":{"price":19.95,"color":"red"}},"email":"amy@only_for_json_udf_test.net","owner":"amy"}
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1962032537/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.owner'), get_json_object(src_json.json, '$.store') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1962032537/10000
-amy	{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"book":[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"bicycle":{"price":19.95,"color":"red"}}
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2019032273/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.bicycle'), get_json_object(src_json.json, '$.store.book') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2019032273/10000
-{"price":19.95,"color":"red"}	[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}]
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2005938063/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0]'), get_json_object(src_json.json, '$.store.book[*]') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2005938063/10000
-{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95}	[{"author":"Nigel Rees","category":"reference","title":"Sayings of the Century","price":8.95},{"author":"Herman Melville","category":"fiction","title":"Moby Dick","price":8.99,"isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","category":"fiction","title":"The Lord of the Rings","price":22.99,"reader":[{"name":"bob","age":25},{"name":"jack","age":26}],"isbn":"0-395-19395-8"}]
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/132584872/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[0].category'), get_json_object(src_json.json, '$.store.book[*].category'), get_json_object(src_json.json, '$.store.book[*].isbn'), get_json_object(src_json.json, '$.store.book[*].reader') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/132584872/10000
-reference	["reference","fiction","fiction"]	["0-553-21311-3","0-395-19395-8"]	[{"name":"bob","age":25},{"name":"jack","age":26}]
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age')  FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1371238792/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.book[*].reader[0].age'), get_json_object(src_json.json, '$.store.book[*].reader[*].age')  FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1371238792/10000
-25	[25,26]
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1801151655/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.store.basket[0][1]'), get_json_object(src_json.json, '$.store.basket[*]'), get_json_object(src_json.json, '$.store.basket[*][0]'), get_json_object(src_json.json, '$.store.basket[0][*]'), get_json_object(src_json.json, '$.store.basket[*][*]'), get_json_object(src_json.json, '$.store.basket[0][2].b'), get_json_object(src_json.json, '$.store.basket[0][*].b') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1801151655/10000
-2	[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]]	1	[1,2,{"b":"y","a":"x"}]	[1,2,{"b":"y","a":"x"},3,4,5,6]	y	["y"]
-PREHOOK: query: SELECT get_json_object(src_json.json, '$.non_exist_key'),  get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src_json
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1780114809/10000
-POSTHOOK: query: SELECT get_json_object(src_json.json, '$.non_exist_key'),  get_json_object(src_json.json, '$..no_recursive'), get_json_object(src_json.json, '$.store.book[10]'), get_json_object(src_json.json, '$.store.book[0].non_exist_key'), get_json_object(src_json.json, '$.store.basket[*].non_exist_key'), get_json_object(src_json.json, '$.store.basket[0][*].non_exist_key') FROM src_json
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src_json
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1780114809/10000
-NULL	NULL	NULL	NULL	NULL	NULL

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lcase.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lcase.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lcase.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lcase.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,14 @@
+PREHOOK: query: DESCRIBE FUNCTION lcase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION lcase
+POSTHOOK: type: DESCFUNCTION
+lcase(str) - Returns str with all characters changed to lowercase
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED lcase
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lcase
+POSTHOOK: type: DESCFUNCTION
+lcase(str) - Returns str with all characters changed to lowercase
+Synonyms: lower
+Example:
+  > SELECT lcase('Facebook') FROM src LIMIT 1;
+  'facebook'

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthan.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthan.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthan.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthan.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION <
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION <
+POSTHOOK: type: DESCFUNCTION
+a < b - Returns TRUE if a is less than b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED <
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <
+POSTHOOK: type: DESCFUNCTION
+a < b - Returns TRUE if a is less than b

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lessthanorequal.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION <=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION <=
+POSTHOOK: type: DESCFUNCTION
+a <= b - Returns TRUE if b is not greater than a
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED <=
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED <=
+POSTHOOK: type: DESCFUNCTION
+a <= b - Returns TRUE if b is not greater than a

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ln.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ln.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ln.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ln.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION ln
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ln
+POSTHOOK: type: DESCFUNCTION
+ln(x) - Returns the natural logarithm of x
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ln
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ln
+POSTHOOK: type: DESCFUNCTION
+ln(x) - Returns the natural logarithm of x
+Example:
+  > SELECT ln(1) FROM src LIMIT 1;
+  0

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION log
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION log
+POSTHOOK: type: DESCFUNCTION
+log([b], x) - Returns the logarithm of x with base b
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED log
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED log
+POSTHOOK: type: DESCFUNCTION
+log([b], x) - Returns the logarithm of x with base b
+Example:
+  > SELECT log(13, 13) FROM src LIMIT 1;
+  1

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log10.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log10.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log10.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION log10
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION log10
+POSTHOOK: type: DESCFUNCTION
+log10(x) - Returns the logarithm of x with base 10
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED log10
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED log10
+POSTHOOK: type: DESCFUNCTION
+log10(x) - Returns the logarithm of x with base 10
+Example:
+  > SELECT log10(10) FROM src LIMIT 1;
+  1

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log2.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log2.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_log2.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION log2
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION log2
+POSTHOOK: type: DESCFUNCTION
+log2(x) - Returns the logarithm of x with base 2
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED log2
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED log2
+POSTHOOK: type: DESCFUNCTION
+log2(x) - Returns the logarithm of x with base 2
+Example:
+  > SELECT log2(2) FROM src LIMIT 1;
+  1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lower.q.out Thu Jan  7 21:54:33 2010
@@ -8,6 +8,7 @@
 POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lower
 POSTHOOK: type: DESCFUNCTION
 lower(str) - Returns str with all characters changed to lowercase
+Synonyms: lcase
 Example:
   > SELECT lower('Facebook') FROM src LIMIT 1;
   'facebook'
@@ -61,9 +62,9 @@
 PREHOOK: query: SELECT lower('AbC 123'), upper('AbC 123') FROM src WHERE key = 86
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1887044838/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1144815521/10000
 POSTHOOK: query: SELECT lower('AbC 123'), upper('AbC 123') FROM src WHERE key = 86
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1887044838/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1144815521/10000
 abc 123	ABC 123

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,80 @@
+PREHOOK: query: DESCRIBE FUNCTION lpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION lpad
+POSTHOOK: type: DESCFUNCTION
+lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
+POSTHOOK: type: DESCFUNCTION
+lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
+If str is longer than len, the return value is shortened to len characters.
+Example:
+  > SELECT lpad('hi', 5, '??') FROM src LIMIT 1;
+  '???hi'  > SELECT lpad('hi', 1, '??') FROM src LIMIT 1;
+  'h'
+PREHOOK: query: EXPLAIN SELECT
+  lpad('hi', 1, '?'),
+  lpad('hi', 5, '.'),
+  lpad('hi', 6, '123')
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN SELECT
+  lpad('hi', 1, '?'),
+  lpad('hi', 5, '.'),
+  lpad('hi', 6, '123')
+FROM src 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 lpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 6 '123'))) (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: lpad('hi', 1, '?')
+                    type: string
+                    expr: lpad('hi', 5, '.')
+                    type: string
+                    expr: lpad('hi', 6, '123')
+                    type: string
+              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: SELECT
+  lpad('hi', 1, '?'),
+  lpad('hi', 5, '.'),
+  lpad('hi', 6, '123')
+FROM src LIMIT 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1156683769/10000
+POSTHOOK: query: SELECT
+  lpad('hi', 1, '?'),
+  lpad('hi', 5, '.'),
+  lpad('hi', 6, '123')
+FROM src LIMIT 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/1156683769/10000
+h	...hi	1231hi

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_lpad_rpad.q.out Thu Jan  7 21:54:33 2010
@@ -1,160 +0,0 @@
-PREHOOK: query: DESCRIBE FUNCTION lpad
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION lpad
-POSTHOOK: type: DESCFUNCTION
-lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED lpad
-POSTHOOK: type: DESCFUNCTION
-lpad(str, len, pad) - Returns str, left-padded with pad to a length of len
-If str is longer than len, the return value is shortened to len characters.
-Example:
-  > SELECT lpad('hi', 5, '??') FROM src LIMIT 1;
-  '???hi'  > SELECT lpad('hi', 1, '??') FROM src LIMIT 1;
-  'h'
-PREHOOK: query: DESCRIBE FUNCTION rpad
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION rpad
-POSTHOOK: type: DESCFUNCTION
-rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
-PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED rpad
-POSTHOOK: type: DESCFUNCTION
-rpad(str, len, pad) - Returns str, right-padded with pad to a length of len
-If str is longer than len, the return value is shortened to len characters.
-Example:
-  > SELECT rpad('hi', 5, '??') FROM src LIMIT 1;
-  'hi???'  > SELECT rpad('hi', 1, '??') FROM src LIMIT 1;
-  'h'
-PREHOOK: query: EXPLAIN SELECT
-  lpad('hi', 1, '?'),
-  lpad('hi', 5, '.'),
-  lpad('hi', 6, '123')
-FROM src LIMIT 1
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT
-  lpad('hi', 1, '?'),
-  lpad('hi', 5, '.'),
-  lpad('hi', 6, '123')
-FROM src 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 lpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION lpad 'hi' 6 '123'))) (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: lpad('hi', 1, '?')
-                    type: string
-                    expr: lpad('hi', 5, '.')
-                    type: string
-                    expr: lpad('hi', 6, '123')
-                    type: string
-              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: SELECT
-  lpad('hi', 1, '?'),
-  lpad('hi', 5, '.'),
-  lpad('hi', 6, '123')
-FROM src LIMIT 1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/361452356/10000
-POSTHOOK: query: SELECT
-  lpad('hi', 1, '?'),
-  lpad('hi', 5, '.'),
-  lpad('hi', 6, '123')
-FROM src LIMIT 1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/361452356/10000
-h	...hi	1231hi
-PREHOOK: query: EXPLAIN SELECT
-  rpad('hi', 1, '?'),
-  rpad('hi', 5, '.'),
-  rpad('hi', 6, '123')
-FROM src LIMIT 1
-PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT
-  rpad('hi', 1, '?'),
-  rpad('hi', 5, '.'),
-  rpad('hi', 6, '123')
-FROM src 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 rpad 'hi' 1 '?')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 5 '.')) (TOK_SELEXPR (TOK_FUNCTION rpad 'hi' 6 '123'))) (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: rpad('hi', 1, '?')
-                    type: string
-                    expr: rpad('hi', 5, '.')
-                    type: string
-                    expr: rpad('hi', 6, '123')
-                    type: string
-              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: SELECT
-  rpad('hi', 1, '?'),
-  rpad('hi', 5, '.'),
-  rpad('hi', 6, '123')
-FROM src LIMIT 1
-PREHOOK: type: QUERY
-PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1704470803/10000
-POSTHOOK: query: SELECT
-  rpad('hi', 1, '?'),
-  rpad('hi', 5, '.'),
-  rpad('hi', 6, '123')
-FROM src LIMIT 1
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1704470803/10000
-h	hi...	hi1231

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ltrim.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ltrim.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ltrim.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_ltrim.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,13 @@
+PREHOOK: query: DESCRIBE FUNCTION ltrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION ltrim
+POSTHOOK: type: DESCFUNCTION
+ltrim(str) - Removes the leading space characters from str 
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED ltrim
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED ltrim
+POSTHOOK: type: DESCFUNCTION
+ltrim(str) - Removes the leading space characters from str 
+Example:
+  > SELECT ltrim('   facebook') FROM src LIMIT 1;
+  'facebook'

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out?rev=897026&r1=897025&r2=897026&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_map.q.out Thu Jan  7 21:54:33 2010
@@ -1,13 +1,11 @@
-PREHOOK: query: -- Parsing bug requires us to quote map
-DESCRIBE FUNCTION 'map'
+PREHOOK: query: DESCRIBE FUNCTION map
 PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: -- Parsing bug requires us to quote map
-DESCRIBE FUNCTION 'map'
+POSTHOOK: query: DESCRIBE FUNCTION map
 POSTHOOK: type: DESCFUNCTION
 map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs 
-PREHOOK: query: DESCRIBE FUNCTION EXTENDED 'map'
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED map
 PREHOOK: type: DESCFUNCTION
-POSTHOOK: query: DESCRIBE FUNCTION EXTENDED 'map'
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED map
 POSTHOOK: type: DESCFUNCTION
 map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs 
 PREHOOK: query: EXPLAIN SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"), 
@@ -62,10 +60,10 @@
 map(1, "a", 2, "b", 3, "c")[2],  map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1878909043/10000
+PREHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/304295935/10000
 POSTHOOK: query: SELECT map(), map(1, "a", 2, "b", 3, "c"), map(1, 2, "a", "b"), 
 map(1, "a", 2, "b", 3, "c")[2],  map(1, 2, "a", "b")["a"], map(1, array("a"))[1][0] FROM src LIMIT 1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1878909043/10000
+POSTHOOK: Output: file:/Users/carl/Projects/hd8/hive-trunk/build/ql/tmp/304295935/10000
 {}	{1:"a",2:"b",3:"c"}	{"1":"2","a":"b"}	b	b	a

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_max.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_max.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_max.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_max.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION max
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION max
+POSTHOOK: type: DESCFUNCTION
+max(expr) - Returns the maximum value of expr
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED max
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED max
+POSTHOOK: type: DESCFUNCTION
+max(expr) - Returns the maximum value of expr

Added: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_min.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_min.q.out?rev=897026&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_min.q.out (added)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_min.q.out Thu Jan  7 21:54:33 2010
@@ -0,0 +1,10 @@
+PREHOOK: query: DESCRIBE FUNCTION min
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION min
+POSTHOOK: type: DESCFUNCTION
+min(expr) - Returns the minimum value of expr
+PREHOOK: query: DESCRIBE FUNCTION EXTENDED min
+PREHOOK: type: DESCFUNCTION
+POSTHOOK: query: DESCRIBE FUNCTION EXTENDED min
+POSTHOOK: type: DESCFUNCTION
+min(expr) - Returns the minimum value of expr



Mime
View raw message