Apache Hive regEx serde: data types

Question

For log processing, I want to use Apache Hive regEx serde, but I found examples that use String as the data type for table columns.

Now my question is: do dates, types and integers and arrays carry, or are they just strings?

In this example (and others), only strings are used:

CREATE TABLE access_log (
  remote_ip STRING,
  request_date STRING,
  method STRING,
  request STRING,
  protocol STRING
)
ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES  (
"input.regex" = "([^ ]) . . [([^]]+)] \"([^ ]) ([^ ]) ([^ \"])\" *",
"output.format.string" = "%1$s %2$s %3$s %4$s %5$s"
)
STORED AS TEXTFILE

;

Answer 1

• Refer to the SERDE code : RegexSerDe or github code - RegexSerDe code , All columns must be of type STRING. - from the comment to the program
• , - Serde ( java, ) , csv custom serde
• , STRING, , Casting (cast() hive).

, :)

Answer 2

RegexSerDe , , : serde/src/java/org/apache/hadoop/hive/serde2/RegexSerDe.java contrib/src/java/org/apache/hadoop/hive/contrib/serde2/RegexSerDe.java

, , , -, . , , .

- , API-.