The options available are
1) Use ORC file format which provides better performance than Text.
2) Use Tez execution engine
3) Use Cost based optimization
4) Use Vectorization execution
5) Right sensible queries that avoids joins
Subscribe to:
Post Comments (Atom)
-
Common Informatica Error Messages and the resolution: 1) ERROR 7/21/2014 5:16:25 PM READER_1_1_1 HIER_28056 XML Reader: Er...
-
How to connect to Amazon Redshift cluster using psql in a unix script and execute a sql statement? You need to first define the following...
-
Netezza datatype conversion function To convert decimal to integer use cast(value as int) in netezza: select cast(12345.30 as int) ...
No comments:
Post a Comment