All Forums Extensibility
tluthra@att.net 2 posts Joined 08/11
23 Apr 2014
SQL-H: Teradata to HDP: License Required?

Hello,
I'm trying to run a SQL-H from Teradata 14.10 VM Image to a Apache Hadoop 2.2.0 single node cluster but it fails.
The query is being run from Teradata Studio. I read in the SQL Quick Reference manual (B035-1510-112B) that this feature is licenced separately. So wondering if it isn't enabled on the VM images that were download from Teradata Developer Exchange Downloads page.
Would anyone know how I can test this feature without enabling it in my production / test clusters?

SELECT id 
     , c_name
     , width 
     , height 
     , depth 
  FROM syslib.load_from_hcatalog(
 USING server('192.168.100.240')
       port('9083')
       username('hive')
       dbname('default')
       tablename('color')
       columns('*')
       templeton_port('50111')
     ) color; 

Executed as Single statement.  Failed [3707 : 42000] Syntax error, expected something like ';' between the word 'load_from_hcatalog' and '('.
Elapsed time = 00:00:00.008
 
STATEMENT 1: Select Statement failed.

webhcat is up and running

curl -i http://192.168.100.240:50111/templeton/v1/status
HTTP/1.1 200 OK
Content-Type: application/json
Transfer-Encoding: chunked
Server: Jetty(7.6.0.v20120127)

Thanks,
Tej
 

alerner 1 post Joined 12/12
27 Jun 2014

I'm having the same problem with both the 14.10 VM and the 15.0 VM.  Is there a way to enable load_from_hcatalog in the VMs?  Is there an additional download?
Thanks,
Andy

Aastha007 6 posts Joined 03/13
06 Aug 2014

Same here. After a proper installation of the TDCH 1.3.1 connector on Teradata Studio 15.00.01 I see this exact error. HDP version used to create Hadoop connection profile in studio is HDP 2.1.
Any ideas on this ?
 
Regards,
Aastha

ahsan.khan 4 posts Joined 07/14
09 Oct 2014

Load_From_HCatalog is a table operator that became available originally with Teradata Aster, to be used together with Teradata DB and Hadoop in Unified Data Architecture (UDA). Aster started off with SQL-H which upgraded to QueryGrid, but it is still in development phase in Teradata 15 as yet. Basically you have to purchase a package for QueryGrid that installs LOAD_FROM_HCATALOG and LOAD_TO_HCATALOG in your Syslib library. You can browse the SYSLIB library in the TD 15 Express VM but it does not have these functions installed by default. As and when you get the package, you can install SQL-H using the instructions here
http://developer.teradata.com/database/articles/teradata-express-support-for-sql-h-install-instructions-sql-h-0

You must sign in to leave a comment.