DWBI-TECH BLOGS (Pradeep Kannadiga)
Informatica, Hive, Hadoop, Amazon Redshift (AWS), Netezza, SQL
Thursday, 15 November 2018
How to make hive queries run faster?
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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Troubleshooting: Common Informatica Error Messages and the resolution
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?
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...
Spector T230- Bluetooth Wireless Speaker - Review
Spector T230- Bluetooth Wireless Speaker - Review If you wondering what is the best gift you can give for christmas or as a corporate gi...
No comments:
Post a Comment