Re: Optimizing SQL Query

2015-03-09 Thread anamika gupta
Please fine the query plan scala sqlContext.sql(SELECT dw.DAY_OF_WEEK, dw.HOUR, avg(dw.SDP_USAGE) AS AVG_SDP_USAGE FROM (SELECT sdp.WID, DAY_OF_WEEK, HOUR, SUM(INTERVAL_VALUE) AS SDP_USAGE FROM (SELECT * FROM date_d AS dd JOIN interval_f AS intf ON intf.DATE_WID = dd.WID WHERE intf.DATE_WID =

Re: Optimizing SQL Query

2015-03-06 Thread daniel queiroz
Dude, please, attach the execution plan of the query and details about the indexes. 2015-03-06 9:07 GMT-03:00 anu anamika.guo...@gmail.com: I have a query that's like: Could you help in providing me pointers as to how to start to optimize it w.r.t. spark sql: sqlContext.sql( SELECT