[ https://issues.apache.org/jira/browse/SPARK-29601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ABHISHEK KUMAR GUPTA updated SPARK-29601:
-----------------------------------------
Description:
Statement column in JDBC/ODBC gives whole SQL statement and page size increases.
Suppose user submit and TPCDS Queries, then Page it display whole Query under statement and
User Experience is not good.
Expected:
It should display the ... Ellipsis and on clicking the stmt. it should Expand display the
whole SQL Statement.
was:
Statement column in JDBC/ODBC gives whole SQL statement and page size increases.
Suppose user submit and TPCDS Queries, then Page it display whole Query under statement and
User Experience is not good.
Expected:
It should display the ... Ellipsis and on clicking the stmt. it should Expand display the
whole SQL Statement.
e.g.
SELECT * FROM (SELECT count(*) h8_30_to_9 FROM store_sales, household_demographics, time_dim,
store WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 8 AND time_dim.t_minute >= 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s1, (SELECT count(*) h9_to_9_30 FROM store_sales, household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 9 AND time_dim.t_minute < 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s2, (SELECT count(*) h9_30_to_10 FROM store_sales, household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 9 AND time_dim.t_minute >= 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s3,(SELECT count(*) h10_to_10_30 FROM store_sales, household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 10 AND time_dim.t_minute < 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s4,(SELECT count(*) h10_30_to_11 FROM store_sales,household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 10 AND time_dim.t_minute >= 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s5,(SELECT count(*) h11_to_11_30 FROM store_sales, household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 11 AND time_dim.t_minute < 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s6,(SELECT count(*) h11_30_to_12 FROM store_sales, household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 11 AND time_dim.t_minute >= 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s7, (SELECT count(*) h12_to_12_30 FROM store_sales, household_demographics, time_dim, store
WHERE ss_sold_time_sk = time_dim.t_time_sk AND ss_hdemo_sk = household_demographics.hd_demo_sk
AND ss_store_sk = s_store_sk AND time_dim.t_hour = 12 AND time_dim.t_minute < 30 AND ((household_demographics.hd_dep_count
= 4 AND household_demographics.hd_vehicle_count <= 4 + 2) OR (household_demographics.hd_dep_count
= 2 AND household_demographics.hd_vehicle_count <= 2 + 2) OR (household_demographics.hd_dep_count
= 0 AND household_demographics.hd_vehicle_count <= 0 + 2)) AND store.s_store_name = 'ese')
s8
> JDBC ODBC Tab Statement column should be provided ellipsis for bigger SQL statement
> -----------------------------------------------------------------------------------
>
> Key: SPARK-29601
> URL: https://issues.apache.org/jira/browse/SPARK-29601
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: ABHISHEK KUMAR GUPTA
> Priority: Major
>
> Statement column in JDBC/ODBC gives whole SQL statement and page size increases.
> Suppose user submit and TPCDS Queries, then Page it display whole Query under statement
and User Experience is not good.
> Expected:
> It should display the ... Ellipsis and on clicking the stmt. it should Expand display
the whole SQL Statement.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org
|