syntax error load_from_hcatalog

Aster
Highlighted
Teradata Employee

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.

1 REPLY
Teradata Employee

Re: syntax error load_from_hcatalog

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.