I have timestamps in ISO-8601 does arcadia support it? how do I use them in arcadia?

Arcadia analytics engine suppor date & time fields in specific format. As described in previous post, the HIVE date type is Unsupported type 'DATE' errors while creating a Dataset

So you want to use either timestamp type or a string types containing ISO8601 date parts (e.g.,YYYY-MM-DD).

+--------------------------|
| a                        |
+--------------------------|
| 2017-02-16T11:24:29.000Z | 
| 2016-03-08T00:34:55Z     | 
| 2017-02-16 11:24:29      | 

You can convert strings to timestamps when in iso 8601 format. Here’s an example how string field can be converted to timestamp or applying date functions like “year”

2 Likes