06-01-2016 02:47 PM
OS: AIX 6.1
SAS: SAS 9.3 M1
ODBC Driver used:- Cloudera ODBC 3.5 for Impala 2.5.30
Issue:- connects fine, but quering is vely slow, takes 30-40 minuts to pull 100000 rows.
If any one has already faced such issue and has g solution to make it fase, would be helpful.
06-01-2016 04:18 PM
Please provide an example of your slow queries. Try doing a count on the same query instead of extracting rows (count(*)) - is that a lot faster? If it is then it is likely that Impala to SAS network connection is the bottleneck. If there is no difference in performance then it is the Impala database that is slow and you would need to talk to a DBA to find out why.