You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by do...@ramyamlab.com on 2018/07/02 04:54:49 UTC
Need help in Apache Drill
Hi there,
Hope you're doing good.
I need suggestion on performance issues which I'm facing in Apache Drill.
Apache Drill version - 1.12.0
DB - MongoDB
Details:
1. For us, it took 9.530 seconds for 1 M records within Apache Drill.
2. Hence, the response time to load page is >12 seconds which is NOT
acceptable SLA.
3. Operators UNORDERED_RECEIVER and UNKNOWN_OPERATOR are taking more
time as per the report below.
4. SQL Query - SELECT ProductName_V AS ProductName,
ROUND(SUM(UnitPrice_N),2) AS UnitPrice FROM XXXX.XXXX.Superstore_1M GROUP
BY ProductName_V
Fragment Profiles
Operator Profiles
Kindly, help me to resolve this issues.
Revert back if you need more details.
Regards,
D Natarajan
Need help in Apache Drill
Posted by do...@ramyamlab.com.
Hi there,
Hope you're doing good.
I need suggestion on performance issues which I'm facing in Apache Drill.
Apache Drill version - 1.12.0
DB - MongoDB
Details:
1. For us, it took 9.530 seconds for 1 M records within Apache Drill.
2. Hence, the response time to load page is >12 seconds which is NOT
acceptable SLA.
3. Operators UNORDERED_RECEIVER and UNKNOWN_OPERATOR are taking more
time as per the report below.
4. SQL Query - SELECT ProductName_V AS ProductName,
ROUND(SUM(UnitPrice_N),2) AS UnitPrice FROM XXXX.XXXX.Superstore_1M GROUP
BY ProductName_V
Fragment Profiles
Operator Profiles
Kindly, help me to resolve this issues.
Revert back if you need more details.
Regards,
D Natarajan
Re: Need help in Apache Drill
Posted by Kunal Khatua <ku...@apache.org>.
Hi
Could you upload the screenshots to a public hosting site and post the links? The Apache mailing list blocks attachments for security reasons.
~ Kunal
On 7/1/2018 10:22:00 PM, dony.natrajan@ramyamlab.com <do...@ramyamlab.com> wrote:
Hi there,
Hope you’re doing good.
I need suggestion on performance issues which I’m facing in Apache Drill.
Apache Drill version – 1.12.0
DB - MongoDB
Details:
* For us, it took 9.530 seconds for 1 M records within Apache Drill.
* Hence, the response time to load page is >12 seconds which is NOT acceptable SLA.
* Operators UNORDERED_RECEIVER and UNKNOWN_OPERATOR are taking more time as per the report below.
* SQL Query - SELECT ProductName_V AS ProductName, ROUND(SUM(UnitPrice_N),2) AS UnitPrice FROM XXXX.XXXX.Superstore_1M GROUP BY ProductName_V
Fragment Profiles
Operator Profiles
Kindly, help me to resolve this issues.
Revert back if you need more details.
Regards,
D Natarajan
Need help in Apache Drill
Posted by do...@ramyamlab.com.
Hi there,
Hope you're doing good.
I need suggestion on performance issues which I'm facing in Apache Drill.
Apache Drill version - 1.12.0
DB - MongoDB
Details:
1. For us, it took 9.530 seconds for 1 M records within Apache Drill.
2. Hence, the response time to load page is >12 seconds which is NOT
acceptable SLA.
3. Operators UNORDERED_RECEIVER and UNKNOWN_OPERATOR are taking more
time as per the report below.
4. SQL Query - SELECT ProductName_V AS ProductName,
ROUND(SUM(UnitPrice_N),2) AS UnitPrice FROM XXXX.XXXX.Superstore_1M GROUP
BY ProductName_V
Fragment Profiles
Operator Profiles
Kindly, help me to resolve this issues.
Revert back if you need more details.
Regards,
D Natarajan