[ https://issues.apache.org/jira/browse/SPARK-29601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16959479#comment-16959479 ]
pavithra ramachandran commented on SPARK-29601: ----------------------------------------------- i shall work on this > 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. > 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org