SUPPORT / SAMPLES & SAS NOTES
Problem Note 63777: SAS® Viya® incorrectly stores Impala tables as text rather than using the specified Parquet format
 |  |  |  |  |
SAS® Data Connector to Impala for SAS Viya incorrectly stores tables as text rather than using the Parquet compression. Sample code that should be stored using the Parquet compression is shown here:
caslib prqt datasource=(
srctype = 'impala'
server = 'myserver.com'
port = #####
impala_dsn = 'your-dsn'
schema = 'your-schema'
dbCreateTableOpts = 'stored as parquet'
);
proc cas;
save caslib="prqt"
name="TESTE_PARQUET_1"
table={caslib="CASUSER", name="your-table"}
replace=true
options={dbCreateTableOpts="stored as parquet"};
quit;
srctype = 'impala'
server = 'myserver.com'
port = #####
impala_dsn = 'your-dsn'
schema = 'your-schema'
dbCreateTableOpts = 'stored as parquet'
);
proc cas;
save caslib="prqt"
name="TESTE_PARQUET_1"
table={caslib="CASUSER", name="your-table"}
replace=true
options={dbCreateTableOpts="stored as parquet"};
quit;
When you run this code, it is incorrectly stored as text.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Data Connector to Impala | Linux for x64 | Viya | |