query: EXPLAIN
SELECT locate('abc', 'abcd'),
       locate('ccc', 'abcabc'),
       locate('23', 123),
       locate(23, 123),
       locate('abc', 'abcabc', 2),
       locate('abc', 'abcabc', '2'),
       locate(1, TRUE),
       locate(1, FALSE),
       locate(CAST('2' AS TINYINT), '12345'),
       locate('34', CAST('12345' AS SMALLINT)),
       locate('456', CAST('123456789012' AS BIGINT)),
       locate('.25', CAST(1.25 AS FLOAT)),
       locate('.0', CAST(16.0 AS DOUBLE)),
       locate(null, 'abc'),
       locate('abc', null),
       locate('abc', 'abcd', null),
       locate('abc', 'abcd', 'invalid number')
FROM src LIMIT 1
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 locate 'abc' 'abcd')) (TOK_SELEXPR (TOK_FUNCTION locate 'ccc' 'abcabc')) (TOK_SELEXPR (TOK_FUNCTION locate '23' 123)) (TOK_SELEXPR (TOK_FUNCTION locate 23 123)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcabc' 2)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcabc' '2')) (TOK_SELEXPR (TOK_FUNCTION locate 1 TRUE)) (TOK_SELEXPR (TOK_FUNCTION locate 1 FALSE)) (TOK_SELEXPR (TOK_FUNCTION locate (TOK_FUNCTION TOK_TINYINT '2') '12345')) (TOK_SELEXPR (TOK_FUNCTION locate '34' (TOK_FUNCTION TOK_SMALLINT '12345'))) (TOK_SELEXPR (TOK_FUNCTION locate '456' (TOK_FUNCTION TOK_BIGINT '123456789012'))) (TOK_SELEXPR (TOK_FUNCTION locate '.25' (TOK_FUNCTION TOK_FLOAT 1.25))) (TOK_SELEXPR (TOK_FUNCTION locate '.0' (TOK_FUNCTION TOK_DOUBLE 16.0))) (TOK_SELEXPR (TOK_FUNCTION locate TOK_NULL 'abc')) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd' TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION locate 'abc' 'abcd' 'invalid number'))) (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: locate('abc''abcd')
                    type: int
                    expr: locate('ccc''abcabc')
                    type: int
                    expr: locate('23'123)
                    type: int
                    expr: locate(23123)
                    type: int
                    expr: locate('abc''abcabc'2)
                    type: int
                    expr: locate('abc''abcabc''2')
                    type: int
                    expr: locate(1true)
                    type: int
                    expr: locate(1false)
                    type: int
                    expr: locate(UDFToByte('2')'12345')
                    type: int
                    expr: locate('34'UDFToShort('12345'))
                    type: int
                    expr: locate('456'UDFToLong('123456789012'))
                    type: int
                    expr: locate('.25'UDFToFloat(1.25))
                    type: int
                    expr: locate('.0'16.0)
                    type: int
                    expr: locate(null'abc')
                    type: int
                    expr: locate('abc'null)
                    type: int
                    expr: locate('abc''abcd'null)
                    type: int
                    expr: locate('abc''abcd''invalid number')
                    type: int
              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13, _col14, _col15, _col16
              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


query: SELECT locate('abc', 'abcd'),
       locate('ccc', 'abcabc'),
       locate('23', 123),
       locate(23, 123),
       locate('abc', 'abcabc', 2),
       locate('abc', 'abcabc', '2'),
       locate(1, TRUE),
       locate(1, FALSE),
       locate(CAST('2' AS TINYINT), '12345'),
       locate('34', CAST('12345' AS SMALLINT)),
       locate('456', CAST('123456789012' AS BIGINT)),
       locate('.25', CAST(1.25 AS FLOAT)),
       locate('.0', CAST(16.0 AS DOUBLE)),
       locate(null, 'abc'),
       locate('abc', null),
       locate('abc', 'abcd', null),
       locate('abc', 'abcd', 'invalid number')
FROM src LIMIT 1
Input: default/src
Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/436151757/10000
1	0	2	2	4	4	0	0	2	3	4	2	3	NULL	NULL	0	0