Hey Fero,
Thank you so much for the response.
I used array_to_string from Postgres, which imported the data in text format in
Hive.
However, couldn’t query that column as an array to get a range based data. I
had to write a UDF.
Thanks
Sowjanya
> On Mar 22, 2018, at 9:22 AM, Fero Szabo wrote
Hi Sowjanya,
I'm only guessing here, but I don't think that this type (Double Precision
array) is supported by Sqoop at all. So, a workaround would be to convert
the data to something else in the database (depending on your use case),
and then import it with sqoop. Text types are easily imported,
Hi Guys,
I am trying to migrate one of the tables from Postgres database to Hive.
Schema of Postgres:
db=> \d table
Table "public.table"
Column |Type| Collation | Nullable | Default
-++---+--+-
cell_id | i
