table_from_afs

Aster
Teradata Employee

table_from_afs

Hello,

I'm trying to get some clarification on the table_from_afs function, specifically the INPUT_FORMAT and SERDE. I installed the set of JARs for Apache's POI for Microsoft Office parsing. I'm trying to parse a Word document using the following code:

 SELECT * FROM table_from_afs(

 ON mr_driver

 PATH('/home/db_superuser/document.doc')

 INPUT_FORMAT('org.apache.poi.xwpf.usermodel.XWPFDocument')

 OUTPUTS ('primary_key varchar')

 );

At the  moment there's no use of SERDE becasue I can't get past an issue with the INPUT_FORMAT. I keep being told that "Failed to instantiate input format or serde. Unsupported input format" or "Serde is not installed" even though I can see it in ACT. Does anyone have any experience parsing work documents in Aster?