spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ABHISHEK KUMAR GUPTA (Jira)" <j...@apache.org>
Subject [jira] [Created] (SPARK-29601) JDBC ODBC Tab Statement column should be provided ellipsis for bigger SQL statement
Date Fri, 25 Oct 2019 06:44:00 GMT
ABHISHEK KUMAR GUPTA created SPARK-29601:
--------------------------------------------

             Summary: 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


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



--
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


Mime
View raw message