All Forums Aster
luca.natali 2 posts Joined 09/15
23 Sep 2015
syntax error load_from_hcatalog

Hi,
I have TD Studio 15.10, TD DB 15.0, HDP 2.0 and Aster 6.0. They are all connected well in TD Studio and I can see the tables.
I'm doing some tests on Aster based on a HDP table but when I execute the query:
 
SELECT * FROM load_from_hcatalog
(USING server('192.168.100.131')
port('9083')
username('root')
dbname('db')
tablename('table')
columns('*')
templeton_port('50111')
) AS table1;
 
It gives me an error:
Executed as Single statement. Failed [34 : 42000] [AsterData][ASTERJDBCDSII](34) ERROR: syntax error at or near "USING" ()
 
Can you help me? Where is the error in the syntax?
Thanks.
 

-------------------------------------------------------- Luca Natali https://it.linkedin.com/in/lucanatali
fgrimmer 553 posts Joined 04/09
23 Sep 2015

Luca, Since the error is coming from Aster JDBC driver and not Studio, I have moved the topic to the Aster Forum for an answer from the Aster folks. thanks.

You must sign in to leave a comment.