You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Babulal (JIRA)" <ji...@apache.org> on 2018/05/29 14:34:00 UTC
[jira] [Created] (CARBONDATA-2563) Explain query with Order by
operator is fired Spark Job which is increase explain query time
Babulal created CARBONDATA-2563:
-----------------------------------
Summary: Explain query with Order by operator is fired Spark Job which is increase explain query time
Key: CARBONDATA-2563
URL: https://issues.apache.org/jira/browse/CARBONDATA-2563
Project: CarbonData
Issue Type: Bug
Reporter: Babulal
Attachments: image-2018-05-29-20-02-58-129.png
Create Table (hive or carbon )
create table justtesthive( name string,age int)
insert into justtesthive select 'babu',12;
WithCarbonSession means startCarbonThriftserver
Without CarbonSession (with SparkSession)
0: jdbc:hive2://10.18.222.231:23040> explain select name from justtesthive order by name;
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| plan |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| == Physical Plan ==
*Sort [name#15 ASC NULLS FIRST], true, 0
+- Exchange rangepartitioning(name#15 ASC NULLS FIRST, 200)
+- HiveTableScan [name#15], HiveTableRelation `default`.`justtesthive`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [name#15, age#16] |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
1 row selected (0.089 seconds)
0: jdbc:hive2://10.18.222.231:23040>
With CarbonSession.
0: jdbc:hive2://10.18.222.231:23040> explain select name from justtesthive order by name;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| plan |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| == CarbonData Profiler ==
|
| == Physical Plan ==
*Sort [name#1867 ASC NULLS FIRST], true, 0
+- Exchange rangepartitioning(name#1867 ASC NULLS FIRST, 200)
+- HiveTableScan [name#1867], HiveTableRelation `default`.`justtesthive`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [name#1867, age#1868] |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
2 rows selected (11.609 seconds)
Time taken by explain is 10 sec for CarbonSession because SparkJob is fired , but for Explain Job should not fired .
!image-2018-05-29-20-02-58-129.png!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)