From issues-return-239887-apmail-spark-issues-archive=spark.apache.org@spark.apache.org Tue Oct 29 04:30:05 2019 Return-Path: X-Original-To: apmail-spark-issues-archive@minotaur.apache.org Delivered-To: apmail-spark-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by minotaur.apache.org (Postfix) with SMTP id BF05E19DF8 for ; Tue, 29 Oct 2019 04:30:04 +0000 (UTC) Received: (qmail 15188 invoked by uid 500); 29 Oct 2019 04:30:03 -0000 Delivered-To: apmail-spark-issues-archive@spark.apache.org Received: (qmail 15130 invoked by uid 500); 29 Oct 2019 04:30:03 -0000 Mailing-List: contact issues-help@spark.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list issues@spark.apache.org Received: (qmail 14891 invoked by uid 99); 29 Oct 2019 04:30:02 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Oct 2019 04:30:02 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 9A232E3141 for ; Tue, 29 Oct 2019 04:30:01 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 656197808D9 for ; Tue, 29 Oct 2019 04:30:00 +0000 (UTC) Date: Tue, 29 Oct 2019 04:30:00 +0000 (UTC) From: "ABHISHEK KUMAR GUPTA (Jira)" To: issues@spark.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (SPARK-29601) JDBC ODBC Tab Statement column should be provided ellipsis for bigger SQL statement MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/SPARK-29601?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:all-tabpanel ] ABHISHEK KUMAR GUPTA updated SPARK-29601: ----------------------------------------- Description:=20 Statement column in JDBC/ODBC gives whole SQL statement and page size incre= ases. Suppose user submit and TPCDS Queries, then Page it display whole Query und= er statement and User Experience is not good. Expected: It should display the ... Ellipsis and on clicking the stmt. it should Expa= nd display the whole SQL Statement. =C2=A0 was: Statement column in JDBC/ODBC gives whole SQL statement and page size incre= ases. Suppose user submit and TPCDS Queries, then Page it display whole Query und= er statement and User Experience is not good. Expected: It should display the ... Ellipsis and on clicking the stmt. it should Expa= nd display the whole SQL Statement. e.g. SELECT * FROM (SELECT count(*) h8_30_to_9 FROM store_sales, household_demog= raphics, time_dim, store WHERE ss_sold_time_sk =3D time_dim.t_time_sk AND s= s_hdemo_sk =3D household_demographics.hd_demo_sk AND ss_store_sk =3D s_stor= e_sk AND time_dim.t_hour =3D 8 AND time_dim.t_minute >=3D 30 AND ((househol= d_demographics.hd_dep_count =3D 4 AND household_demographics.hd_vehicle_cou= nt <=3D 4 + 2) OR (household_demographics.hd_dep_count =3D 2 AND household_= demographics.hd_vehicle_count <=3D 2 + 2) OR (household_demographics.hd_dep= _count =3D 0 AND household_demographics.hd_vehicle_count <=3D 0 + 2)) AND s= tore.s_store_name =3D 'ese') s1, (SELECT count(*) h9_to_9_30 FROM store_sal= es, household_demographics, time_dim, store WHERE ss_sold_time_sk =3D time_= dim.t_time_sk AND ss_hdemo_sk =3D household_demographics.hd_demo_sk AND ss_= store_sk =3D s_store_sk AND time_dim.t_hour =3D 9 AND time_dim.t_minute < 3= 0 AND ((household_demographics.hd_dep_count =3D 4 AND household_demographic= s.hd_vehicle_count <=3D 4 + 2) OR (household_demographics.hd_dep_count =3D = 2 AND household_demographics.hd_vehicle_count <=3D 2 + 2) OR (household_dem= ographics.hd_dep_count =3D 0 AND household_demographics.hd_vehicle_count <= =3D 0 + 2)) AND store.s_store_name =3D 'ese') s2, (SELECT count(*) h9_30_to= _10 FROM store_sales, household_demographics, time_dim, store WHERE ss_sold= _time_sk =3D time_dim.t_time_sk AND ss_hdemo_sk =3D household_demographics.= hd_demo_sk AND ss_store_sk =3D s_store_sk AND time_dim.t_hour =3D 9 AND tim= e_dim.t_minute >=3D 30 AND ((household_demographics.hd_dep_count =3D 4 AND = household_demographics.hd_vehicle_count <=3D 4 + 2) OR (household_demograph= ics.hd_dep_count =3D 2 AND household_demographics.hd_vehicle_count <=3D 2 += 2) OR (household_demographics.hd_dep_count =3D 0 AND household_demographic= s.hd_vehicle_count <=3D 0 + 2)) AND store.s_store_name =3D 'ese') s3,(SELEC= T count(*) h10_to_10_30 FROM store_sales, household_demographics, time_dim,= store WHERE ss_sold_time_sk =3D time_dim.t_time_sk AND ss_hdemo_sk =3D hou= sehold_demographics.hd_demo_sk AND ss_store_sk =3D s_store_sk AND time_dim.= t_hour =3D 10 AND time_dim.t_minute < 30 AND ((household_demographics.hd_de= p_count =3D 4 AND household_demographics.hd_vehicle_count <=3D 4 + 2) OR (h= ousehold_demographics.hd_dep_count =3D 2 AND household_demographics.hd_vehi= cle_count <=3D 2 + 2) OR (household_demographics.hd_dep_count =3D 0 AND hou= sehold_demographics.hd_vehicle_count <=3D 0 + 2)) AND store.s_store_name = =3D 'ese') s4,(SELECT count(*) h10_30_to_11 FROM store_sales,household_demo= graphics, time_dim, store WHERE ss_sold_time_sk =3D time_dim.t_time_sk AND = ss_hdemo_sk =3D household_demographics.hd_demo_sk AND ss_store_sk =3D s_sto= re_sk AND time_dim.t_hour =3D 10 AND time_dim.t_minute >=3D 30 AND ((househ= old_demographics.hd_dep_count =3D 4 AND household_demographics.hd_vehicle_c= ount <=3D 4 + 2) OR (household_demographics.hd_dep_count =3D 2 AND househol= d_demographics.hd_vehicle_count <=3D 2 + 2) OR (household_demographics.hd_d= ep_count =3D 0 AND household_demographics.hd_vehicle_count <=3D 0 + 2)) AND= store.s_store_name =3D 'ese') s5,(SELECT count(*) h11_to_11_30 FROM store_= sales, household_demographics, time_dim, store WHERE ss_sold_time_sk =3D ti= me_dim.t_time_sk AND ss_hdemo_sk =3D household_demographics.hd_demo_sk AND = ss_store_sk =3D s_store_sk AND time_dim.t_hour =3D 11 AND time_dim.t_minute= < 30 AND ((household_demographics.hd_dep_count =3D 4 AND household_demogra= phics.hd_vehicle_count <=3D 4 + 2) OR (household_demographics.hd_dep_count = =3D 2 AND household_demographics.hd_vehicle_count <=3D 2 + 2) OR (household= _demographics.hd_dep_count =3D 0 AND household_demographics.hd_vehicle_coun= t <=3D 0 + 2)) AND store.s_store_name =3D 'ese') s6,(SELECT count(*) h11_30= _to_12 FROM store_sales, household_demographics, time_dim, store WHERE ss_s= old_time_sk =3D time_dim.t_time_sk AND ss_hdemo_sk =3D household_demographi= cs.hd_demo_sk AND ss_store_sk =3D s_store_sk AND time_dim.t_hour =3D 11 AND= time_dim.t_minute >=3D 30 AND ((household_demographics.hd_dep_count =3D 4 = AND household_demographics.hd_vehicle_count <=3D 4 + 2) OR (household_demog= raphics.hd_dep_count =3D 2 AND household_demographics.hd_vehicle_count <=3D= 2 + 2) OR (household_demographics.hd_dep_count =3D 0 AND household_demogra= phics.hd_vehicle_count <=3D 0 + 2)) AND store.s_store_name =3D 'ese') s7, (= SELECT count(*) h12_to_12_30 FROM store_sales, household_demographics, time= _dim, store WHERE ss_sold_time_sk =3D time_dim.t_time_sk AND ss_hdemo_sk = =3D household_demographics.hd_demo_sk AND ss_store_sk =3D s_store_sk AND ti= me_dim.t_hour =3D 12 AND time_dim.t_minute < 30 AND ((household_demographic= s.hd_dep_count =3D 4 AND household_demographics.hd_vehicle_count <=3D 4 + 2= ) OR (household_demographics.hd_dep_count =3D 2 AND household_demographics.= hd_vehicle_count <=3D 2 + 2) OR (household_demographics.hd_dep_count =3D 0 = AND household_demographics.hd_vehicle_count <=3D 0 + 2)) AND store.s_store_= name =3D '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 inc= reases. > Suppose user submit and TPCDS Queries, then Page it display whole Query u= nder statement and User Experience is not good. > Expected: > It should display the ... Ellipsis and on clicking the stmt. it should Ex= pand display the whole SQL Statement. > =C2=A0 -- 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