PREHOOK: query: DESCRIBE FUNCTION concat_ws
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION concat_ws
POSTHOOK: type: DESCFUNCTION
concat_ws(separator, [string | array(string)]+) - returns the concatenation of the strings separated by the separator.
PREHOOK: query: DESCRIBE FUNCTION EXTENDED concat_ws
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED concat_ws
POSTHOOK: type: DESCFUNCTION
concat_ws(separator, [string | array(string)]+) - returns the concatenation of the strings separated by the separator.
Example:
  > SELECT concat_ws('.', 'www', array('facebook', 'com')) FROM src LIMIT 1;
  'www.facebook.com'
PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT 'abc', 'xyz', '8675309'  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', 'xyz', '8675309'  WHERE src.key = 86
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.c1 SIMPLE []
POSTHOOK: Lineage: dest1.c2 SIMPLE []
POSTHOOK: Lineage: dest1.c3 SIMPLE []
PREHOOK: query: EXPLAIN
SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
       concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
       concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
       concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
       concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
       concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
       concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: dest1
          Statistics: Num rows: 1 Data size: 15 Basic stats: COMPLETE Column stats: NONE
          Select Operator
            expressions: concat_ws(c1, c2, c3) (type: string), concat_ws(',', c1, c2, c3) (type: string), concat_ws(null, c1, c2, c3) (type: string), concat_ws('**', c1, null, c3) (type: string)
            outputColumnNames: _col0, _col1, _col2, _col3
            Statistics: Num rows: 1 Data size: 15 Basic stats: COMPLETE Column stats: NONE
            ListSink

PREHOOK: query: SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
       concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
       concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
       concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: query: SELECT concat_ws(dest1.c1, dest1.c2, dest1.c3),
       concat_ws(',', dest1.c1, dest1.c2, dest1.c3),
       concat_ws(NULL, dest1.c1, dest1.c2, dest1.c3),
       concat_ws('**', dest1.c1, NULL, dest1.c3) FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
xyzabc8675309	abc,xyz,8675309	NULL	abc**8675309
PREHOOK: query: -- evalutes function for array of strings
EXPLAIN
SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
       concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
       concat_ws('F', 'www', array('face', 'book', 'com', '1234')),
       concat_ws('_', array('www', 'face'), array('book', 'com', '1234')),
       concat_ws('**', 'www', array('face'), array('book', 'com', '1234')),
       concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
       concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows)
PREHOOK: type: QUERY
POSTHOOK: query: -- evalutes function for array of strings
EXPLAIN
SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
       concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
       concat_ws('F', 'www', array('face', 'book', 'com', '1234')),
       concat_ws('_', array('www', 'face'), array('book', 'com', '1234')),
       concat_ws('**', 'www', array('face'), array('book', 'com', '1234')),
       concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
       concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: dest1
          Row Limit Per Split: 1
          Statistics: Num rows: 1 Data size: 15 Basic stats: COMPLETE Column stats: COMPLETE
          Select Operator
            expressions: concat_ws('.', array('www','face','book','com'), '1234') (type: string), concat_ws('-', 'www', array('face','book','com'), '1234') (type: string), concat_ws('F', 'www', array('face','book','com','1234')) (type: string), concat_ws('_', array('www','face'), array('book','com','1234')) (type: string), concat_ws('**', 'www', array('face'), array('book','com','1234')) (type: string), concat_ws('[]', array('www'), 'face', array('book','com','1234')) (type: string), concat_ws('AAA', array('www'), array('face','book','com'), '1234') (type: string)
            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
            Statistics: Num rows: 1 Data size: 758 Basic stats: COMPLETE Column stats: COMPLETE
            ListSink

PREHOOK: query: SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
       concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
       concat_ws('F', 'www', array('face', 'book', 'com', '1234')),
       concat_ws('_', array('www', 'face'), array('book', 'com', '1234')),
       concat_ws('**', 'www', array('face'), array('book', 'com', '1234')),
       concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
       concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: query: SELECT concat_ws('.', array('www', 'face', 'book', 'com'), '1234'),
       concat_ws('-', 'www', array('face', 'book', 'com'), '1234'),
       concat_ws('F', 'www', array('face', 'book', 'com', '1234')),
       concat_ws('_', array('www', 'face'), array('book', 'com', '1234')),
       concat_ws('**', 'www', array('face'), array('book', 'com', '1234')),
       concat_ws('[]', array('www'), 'face', array('book', 'com', '1234')),
       concat_ws('AAA', array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
www.face.book.com.1234	www-face-book-com-1234	wwwFfaceFbookFcomF1234	www_face_book_com_1234	www**face**book**com**1234	www[]face[]book[]com[]1234	wwwAAAfaceAAAbookAAAcomAAA1234
PREHOOK: query: SELECT concat_ws(NULL, array('www', 'face', 'book', 'com'), '1234'),
       concat_ws(NULL, 'www', array('face', 'book', 'com'), '1234'),
       concat_ws(NULL, 'www', array('face', 'book', 'com', '1234')),
       concat_ws(NULL, array('www', 'face'), array('book', 'com', '1234')),
       concat_ws(NULL, 'www', array('face'), array('book', 'com', '1234')),
       concat_ws(NULL, array('www'), 'face', array('book', 'com', '1234')),
       concat_ws(NULL, array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows)
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: query: SELECT concat_ws(NULL, array('www', 'face', 'book', 'com'), '1234'),
       concat_ws(NULL, 'www', array('face', 'book', 'com'), '1234'),
       concat_ws(NULL, 'www', array('face', 'book', 'com', '1234')),
       concat_ws(NULL, array('www', 'face'), array('book', 'com', '1234')),
       concat_ws(NULL, 'www', array('face'), array('book', 'com', '1234')),
       concat_ws(NULL, array('www'), 'face', array('book', 'com', '1234')),
       concat_ws(NULL, array('www'), array('face', 'book', 'com'), '1234') FROM dest1 tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
NULL	NULL	NULL	NULL	NULL	NULL	NULL