topic Re: loading Hadoop Hive Data in SAS Table in SAS Data Management

loading Hadoop Hive Data in SAS Table

barlocaroni — Fri, 21 Jul 2017 16:43:58 GMT

Hi, I'm trying to load a SAS dataset extracting data from a Hadoop Hive View.

Is it possible or should I mandatorily use a Hadoop Hive Table ?

Thanks in advance

Carlo

Re: loading Hadoop Hive Data in SAS Table

LinusH — Fri, 21 Jul 2017 21:10:16 GMT

If your view is visible from your SAS/ACCESS libref you should be able to query it, and store the result in any data store available to your SAS session (GIVEN that you have write permissions).
It sounds like you have run into some kind of obstacle. Please provide specific info like a log if you need further assistance.

Re: loading Hadoop Hive Data in SAS Table

barlocaroni — Sat, 22 Jul 2017 21:46:01 GMT

Hi LinusH, I tried again with my Hadoop view (not a table). Using Options sastrace=',,,d' sastraceloc=saslog nostsuffix I've found in the log a problem in the Hadoop View: there were some text fields defined as "string" so I incurred in the "32767 length" problem and my table was too big for the space allowed. So thank you very much, Carlo

Re: loading Hadoop Hive Data in SAS Table

rah12 — Fri, 20 Apr 2018 12:14:21 GMT

Is it possible in sas University Edition to load Hive Data in Sas Table.

Re: loading Hadoop Hive Data in SAS Table

LinusH — Fri, 20 Apr 2018 15:23:45 GMT

New question, new thread.
And no, only ACCESS to PC Files is included.

Re: loading Hadoop Hive Data in SAS Table

rah12 — Tue, 24 Apr 2018 05:47:21 GMT

Is it possible in sas 9.4 version.

To load hive table data.

Re: loading Hadoop Hive Data in SAS Table

LinusH — Tue, 24 Apr 2018 20:26:06 GMT

If you refer to the regular SAS (not University ed), yes with SAS/ACCESS to Hadoop.

Re: loading Hadoop Hive Data in SAS Table

rah12 — Wed, 02 May 2018 08:43:55 GMT

Thanks for response . Can we Access Sas with Emr Hive ?

Re: loading Hadoop Hive Data in SAS Table

LinusH — Wed, 02 May 2018 15:58:24 GMT

Emr?

Re: loading Hadoop Hive Data in SAS Table

rah12 — Thu, 03 May 2018 04:54:27 GMT

I have a aws Hive and which files are stored in S3. Can we accees tables of Hive using Sas?.

Re: loading Hadoop Hive Data in SAS Table

LinusH — Fri, 04 May 2018 06:19:06 GMT

I think your next step is to contact your SAS sales representative. SAS should be happy helping you choosing and designing your analytics environment.