Member since
07-23-2015
2
Posts
0
Kudos Received
0
Solutions
07-24-2015
09:31 AM
We have an AVRO file that we imported with sqoop that contains some dates with "0000" year and some other dates with "9999". Apparently the upper bound is not a problem and is common between the two systems, but the lower bound is giving us a headache. What is the standard practice to deal with this?
... View more
07-23-2015
02:35 AM
I tried creating a table with the following command: create table foo
stored as parquet
as
select cast('0001-01-01 00:00:00' as timestamp) ts; If I launch such command in Impala, the timestamp becomes a NULL value and from that moment on both Hive and Impala see the content as NULL. However, if I create the table using Hive the timestamp is preserved and I can see it correctly within Hive, but Impala shows the following error: Year is out of valid range: 1400..10000 How can I handle this issue? I need both parquet format and the Impala connection.
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala