PageRenderTime 26ms CodeModel.GetById 17ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_reflect.q.out

#
text | 150 lines | 143 code | 7 blank | 0 comment | 0 complexity | e2a0591696eaef7e53dd02f2e969f96a MD5 | raw file
  1PREHOOK: query: DESCRIBE FUNCTION reflect
  2PREHOOK: type: DESCFUNCTION
  3POSTHOOK: query: DESCRIBE FUNCTION reflect
  4POSTHOOK: type: DESCFUNCTION
  5reflect(class,method[,arg1[,arg2..]]) calls method with reflection
  6PREHOOK: query: DESCRIBE FUNCTION EXTENDED reflect
  7PREHOOK: type: DESCFUNCTION
  8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED reflect
  9POSTHOOK: type: DESCFUNCTION
 10reflect(class,method[,arg1[,arg2..]]) calls method with reflection
 11Use this UDF to call Java methods by matching the argument signature
 12
 13PREHOOK: query: EXPLAIN EXTENDED
 14SELECT reflect("java.lang.String", "valueOf", 1),
 15       reflect("java.lang.String", "isEmpty"),
 16       reflect("java.lang.Math", "max", 2, 3),
 17       reflect("java.lang.Math", "min", 2, 3),
 18       reflect("java.lang.Math", "round", 2.5),
 19       reflect("java.lang.Math", "exp", 1.0),
 20       reflect("java.lang.Math", "floor", 1.9)
 21FROM src LIMIT 1
 22PREHOOK: type: QUERY
 23POSTHOOK: query: EXPLAIN EXTENDED
 24SELECT reflect("java.lang.String", "valueOf", 1),
 25       reflect("java.lang.String", "isEmpty"),
 26       reflect("java.lang.Math", "max", 2, 3),
 27       reflect("java.lang.Math", "min", 2, 3),
 28       reflect("java.lang.Math", "round", 2.5),
 29       reflect("java.lang.Math", "exp", 1.0),
 30       reflect("java.lang.Math", "floor", 1.9)
 31FROM src LIMIT 1
 32POSTHOOK: type: QUERY
 33ABSTRACT SYNTAX TREE:
 34  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.String" "valueOf" 1)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.String" "isEmpty")) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "max" 2 3)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "min" 2 3)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "round" 2.5)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "exp" 1.0)) (TOK_SELEXPR (TOK_FUNCTION reflect "java.lang.Math" "floor" 1.9))) (TOK_LIMIT 1)))
 35
 36STAGE DEPENDENCIES:
 37  Stage-1 is a root stage
 38  Stage-0 is a root stage
 39
 40STAGE PLANS:
 41  Stage: Stage-1
 42    Map Reduce
 43      Alias -> Map Operator Tree:
 44        src 
 45          TableScan
 46            alias: src
 47            GatherStats: false
 48            Select Operator
 49              expressions:
 50                    expr: reflect('java.lang.String','valueOf',1)
 51                    type: string
 52                    expr: reflect('java.lang.String','isEmpty')
 53                    type: string
 54                    expr: reflect('java.lang.Math','max',2,3)
 55                    type: string
 56                    expr: reflect('java.lang.Math','min',2,3)
 57                    type: string
 58                    expr: reflect('java.lang.Math','round',2.5)
 59                    type: string
 60                    expr: reflect('java.lang.Math','exp',1.0)
 61                    type: string
 62                    expr: reflect('java.lang.Math','floor',1.9)
 63                    type: string
 64              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
 65              Limit
 66                File Output Operator
 67                  compressed: false
 68                  GlobalTableId: 0
 69                  directory: file:/tmp/sdong/hive_2011-02-10_17-39-58_293_2781390290372198499/-ext-10001
 70                  NumFilesPerFileSink: 1
 71                  Stats Publishing Key Prefix: file:/tmp/sdong/hive_2011-02-10_17-39-58_293_2781390290372198499/-ext-10001/
 72                  table:
 73                      input format: org.apache.hadoop.mapred.TextInputFormat
 74                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 75                      properties:
 76                        columns _col0,_col1,_col2,_col3,_col4,_col5,_col6
 77                        columns.types string:string:string:string:string:string:string
 78                        serialization.format 1
 79                  TotalFiles: 1
 80                  GatherStats: false
 81                  MultiFileSpray: false
 82      Needs Tagging: false
 83      Path -> Alias:
 84        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src [src]
 85      Path -> Partition:
 86        pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src 
 87          Partition
 88            base file name: src
 89            input format: org.apache.hadoop.mapred.TextInputFormat
 90            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 91            properties:
 92              bucket_count -1
 93              columns key,value
 94              columns.types string:string
 95              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 96              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 97              location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
 98              name default.src
 99              serialization.ddl struct src { string key, string value}
100              serialization.format 1
101              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
102              transient_lastDdlTime 1297378968
103            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
104          
105              input format: org.apache.hadoop.mapred.TextInputFormat
106              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
107              properties:
108                bucket_count -1
109                columns key,value
110                columns.types string:string
111                file.inputformat org.apache.hadoop.mapred.TextInputFormat
112                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
113                location pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/src
114                name default.src
115                serialization.ddl struct src { string key, string value}
116                serialization.format 1
117                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
118                transient_lastDdlTime 1297378968
119              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
120              name: default.src
121            name: default.src
122
123  Stage: Stage-0
124    Fetch Operator
125      limit: 1
126
127
128PREHOOK: query: SELECT reflect("java.lang.String", "valueOf", 1),
129       reflect("java.lang.String", "isEmpty"),
130       reflect("java.lang.Math", "max", 2, 3),
131       reflect("java.lang.Math", "min", 2, 3),
132       reflect("java.lang.Math", "round", 2.5),
133       reflect("java.lang.Math", "exp", 1.0),
134       reflect("java.lang.Math", "floor", 1.9)
135FROM src LIMIT 1
136PREHOOK: type: QUERY
137PREHOOK: Input: default@src
138PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-58_382_6716753430415370105/-mr-10000
139POSTHOOK: query: SELECT reflect("java.lang.String", "valueOf", 1),
140       reflect("java.lang.String", "isEmpty"),
141       reflect("java.lang.Math", "max", 2, 3),
142       reflect("java.lang.Math", "min", 2, 3),
143       reflect("java.lang.Math", "round", 2.5),
144       reflect("java.lang.Math", "exp", 1.0),
145       reflect("java.lang.Math", "floor", 1.9)
146FROM src LIMIT 1
147POSTHOOK: type: QUERY
148POSTHOOK: Input: default@src
149POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-39-58_382_6716753430415370105/-mr-10000
1501	true	3	2	3	2.7182818284590455	1.0