Aster 6.0 to HDP 2.1 select does not work

Aster
Senior Supporter

Aster 6.0 to HDP 2.1 select does not work

Hi,

I installed the UDA on a Stick package and run currently some of the examples.

TD15.0 and Aster 6.0 are runing and working fine.

HDP2.1 is also running. And hive is working on the HDP2.1 - I can run select * from freeze_frames from the hive consol and get results.

But when I run 

select * FROM load_from_hcatalog

(on mr_driver

server('192.168.100.21') dbname('default')

tablename('employee') username('hive')) limit 5;

from 4) Connectors (UDA)/04. Aster-SQL-H.sql

on the aster 6.0 I get the following error message:

Executed as Single statement.  Failed [34 : HY000] [AsterData][ASTERJDBCDSII](34) ERROR: SQL-MR function LOAD_FROM_HCATALOG failed: Failed to initiate data reading from hcatalog table. Details : java.lang.TypeNotPresentException: Type char(20) not present () 

Elapsed time = 00:00:20.697 

STATEMENT 1: Select Statement failed.

on


all services are green

Any idea what need to be done?

Ulrich 

5 REPLIES
Senior Supporter

Re: Aster 6.0 to HDP 2.1 select does not work

Update:

It seems to be an Aster problem as 

SELECT * FROM load_from_hcatalog 

(USING server('192.168.100.21')

port('9083')

username('hive') dbname('default')

tablename('hive_callcenter')

columns('*')

templeton_port('50111')

) as dt sample 5;

runs fine -> HDP2.1 is working...

Teradata Employee

Re: Aster 6.0 to HDP 2.1 select does not work

Ulrich, did you setup UDA on a stick at Mac, if yes from where I can get it?

Teradata Employee

Re: Aster 6.0 to HDP 2.1 select does not work

Hello , i am receiving a similar error when running a query from aster 6.20 to Cloudera 5.4.

ERROR:  SQL-MR function LOAD_FROM_HCATALOG failed: Failed to initiate data reading from hcatalog table. Details : com.google.common.util.concurrent.UncheckedExecutionException: java.lang.NullPointerException

This is the query : 

SELECT * FROM load_from_hcatalog

( ON mr_driver

SERVER('smp200-8_eth4')

USERNAME('hue')

DBNAME('test')

TABLENAME('wine')

 

columns('*')

 

templeton_port('50111')

);

Any ideas pls ??

tks.

Enthusiast

Re: Aster 6.0 to HDP 2.1 select does not work

Hi,

It seems to be a problem from Cloudera. have you made any upgrade to Cloudera server?

Are you able to ping the server 'smp200-8_eth4' from Aster machine?

Khurram
Highlighted
Enthusiast

Re: Aster 6.0 to HDP 2.1 select does not work

Hai All 

i will introduce myself , 

my name is zaky wibowo  

in here , i have a question about query in aster , currently i have some problem about query in aster 

cause , i don't know about query in aster , can you give me references example from query in aster guys ?

please tell me about that guys ..:) 

thanks