RE: Catalyst optimizer cpu/Io cost

2016-06-10 Thread Srinivasan Hariharan02
: Friday, June 10, 2016 3:27 PM To: Srinivasan Hariharan02 Cc: Takeshi Yamamuro ; user@spark.apache.org Subject: Re: Catalyst optimizer cpu/Io cost in an SMP system such as Oracle or Sybase the CBO will take into account LIO, PIO and CPU costing or use some empirical costing. In a distributed system

RE: Catalyst optimizer cpu/Io cost

2016-06-10 Thread Srinivasan Hariharan02
[mailto:linguin@gmail.com] Sent: Friday, June 10, 2016 2:38 PM To: Srinivasan Hariharan02 Cc: user@spark.apache.org Subject: Re: Catalyst optimizer cpu/Io cost Hi, There no way to retrieve that information in spark. In fact, the current optimizer only consider the byte size of outputs in

Catalyst optimizer cpu/Io cost

2016-06-09 Thread Srinivasan Hariharan02
Hi,, How can I get spark sql query cpu and Io cost after optimizing for the best logical plan. Is there any api to retrieve this information?. If anyone point me to the code where actually cpu and Io cost computed in catalyst module. Regards, Srinivasan Hariharan +91-9940395830