All Forums Aster
ulrich 816 posts Joined 09/09
16 Sep 2015
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

http://192.168.100.21:8080/#/main/services/HBASE/ summary

all services are green

 

Any idea what need to be done?

 

Ulrich 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud
ulrich 816 posts Joined 09/09
18 Sep 2015

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...

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

momer 1 post Joined 08/10
26 Jan 2016

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

g_rodrig 1 post Joined 07/10
19 Jul 2016

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.

M.Saeed Khurram 544 posts Joined 09/12
20 Jul 2016

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

zakyw 11 posts Joined 07/16
21 Jul 2016

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  

You must sign in to leave a comment.