0

How to use NOS in Teradata connecting to a EMC Isilon storage S3 service ?

I can't find any document talk about this topic in Teradata. Anyone who did this before can give me some advice.

I create an isilon environment and it can be read by s3cmd https://sourceforge.net/projects/s3tools/files/s3cmd/

BUT I use this NOS command below Get error

SELECT TOP 2 LOCATION FROM Isilon_READ_NOS_FM (
ON (SELECT CAST( NULL AS DATASET STORAGE FORMAT CSV ))
USING
LOCATION('/s3/s3data.s3.isilon.local/')
RETURNTYPE('NOSREAD_RECORD')
) AS D;

this below also got error:

SELECT TOP 2 LOCATION FROM Isilon_READ_NOS_FM (
ON (SELECT CAST( NULL AS DATASET STORAGE FORMAT CSV ))
USING
LOCATION('s3://s3.isilon.local/s3data/')
RETURNTYPE('NOSREAD_RECORD')
) AS D;

If I can't use the method above, any other way make Teradata read S3 storage ?

2015evanotes
  • 89
  • 10
  • May not be officially supported / documented (yet?). Are you running latest Vantage 2.2 / SQL Engine 17.05? – Fred Jun 15 '21 at 23:59
  • YES I run 17.05 . This is not support yet ? – 2015evanotes Jun 16 '21 at 04:07
  • It should be supported as of 17.05, per the Release Summary document. Obviously you would need to use Access ID and Access Key rather than IAM roles, but otherwise seems like you can treat on-premises S3-compatible storage just like S3. – Fred Jun 16 '21 at 14:22
  • Shouldn't RETURNTYPE be `NOSREAD_KEYS` if you are trying to list the objects, i.e. `LOCATION`? For `NOSREAD_RECORD` you would normally refer to `PAYLOAD` in the SELECT. – Fred Jun 16 '21 at 15:34
  • I use Access ID and Access Key to create NOS object like AWS S3 . But connect to ISILON fail. Seems Teradata NOS command use 443 port and ISILON USE 9021 PORT. and have SSL problem. How to ignore SSL certification in Teradata. – 2015evanotes Jun 18 '21 at 02:21
  • https://docs.teradata.com/r/p~0sSD4zl4K8YPbEGnM3Rg/4FhtSoBUKGkyd83JHMletQ – 2015evanotes Jun 18 '21 at 05:28
  • Is this config will effect NOS ? https://docs.teradata.com/r/p~0sSD4zl4K8YPbEGnM3Rg/4FhtSoBUKGkyd83JHMletQ – 2015evanotes Jun 18 '21 at 05:29
  • 1
    That reference is for TPT Access Module, does not apply to NOS. – Fred Jun 18 '21 at 15:23
  • How about this ? add selft signed SSL Certification ? Is this config will effect NOS ? https://docs.teradata.com/r/fU8HstyX~mrNdJ1deohqsA/xydgLvthrf8mDTELlxpLwg – 2015evanotes Jun 21 '21 at 06:23
  • The linked discussion relates to client authentication to the database - does not apply to NOS. – Fred Jun 21 '21 at 15:12

0 Answers0