Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 9A503200C67 for ; Mon, 15 May 2017 10:43:10 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 98EFF160BC2; Mon, 15 May 2017 08:43:10 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 6A873160BC1 for ; Mon, 15 May 2017 10:43:09 +0200 (CEST) Received: (qmail 24518 invoked by uid 500); 15 May 2017 08:43:08 -0000 Mailing-List: contact issues-help@carbondata.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.apache.org Delivered-To: mailing list issues@carbondata.apache.org Received: (qmail 24509 invoked by uid 99); 15 May 2017 08:43:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 15 May 2017 08:43:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 43EC9CD4E1 for ; Mon, 15 May 2017 08:43:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 964zEzTeANUJ for ; Mon, 15 May 2017 08:43:07 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 47D145FC16 for ; Mon, 15 May 2017 08:43:06 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 51EE1E0D5F for ; Mon, 15 May 2017 08:43:05 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 70B1A2430D for ; Mon, 15 May 2017 08:43:04 +0000 (UTC) Date: Mon, 15 May 2017 08:43:04 +0000 (UTC) From: "sounak chakraborty (JIRA)" To: issues@carbondata.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CARBONDATA-1052) Complete result does not display in Sort_column table. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 15 May 2017 08:43:10 -0000 [ https://issues.apache.org/jira/browse/CARBONDATA-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16010172#comment-16010172 ] sounak chakraborty commented on CARBONDATA-1052: ------------------------------------------------ Place all the failing test cases of Sort Column in this single JIRA, which will be easier to track. > Complete result does not display in Sort_column table. > ------------------------------------------------------ > > Key: CARBONDATA-1052 > URL: https://issues.apache.org/jira/browse/CARBONDATA-1052 > Project: CarbonData > Issue Type: Bug > Components: data-load > Environment: Spark 2.1 > Reporter: Vinod Rohilla > Priority: Minor > Attachments: newdata.csv > > > Incomplete result displays to the user while select query. > Steps to reproduces: > 1: Create table: > CREATE TABLE sorttable4_offheap_safe (empno int, empname String, designation String, doj Timestamp, workgroupcategory int, workgroupcategoryname String, deptno int, deptname String, projectcode int, projectjoindate Timestamp, projectenddate Timestamp,attendance int,utilization int,salary int) STORED BY 'org.apache.carbondata.format' tblproperties('sort_columns'='workgroupcategory, empname'); > 2: Load Data > LOAD DATA local inpath 'hdfs://localhost:54310/newdata.csv' INTO TABLE sorttable4_offheap_safe OPTIONS('DELIMITER'= ',', 'QUOTECHAR'= '\"'); > 3: Select Query & result set: > 0: jdbc:hive2://localhost:10000> Select * from sorttable4_offheap_safe; > +--------+-----------+---------------------------------------------------------------+------------------------+--------------------+------------------------+---------+---------------------------------------------------------------+--------------+------------------------+------------------------+-------------+--------------+---------+--+ > | empno | empname | designation | doj | workgroupcategory | workgroupcategoryname | deptno | deptname | projectcode | projectjoindate | projectenddate | attendance | utilization | salary | > +--------+-----------+---------------------------------------------------------------+------------------------+--------------------+------------------------+---------+---------------------------------------------------------------+--------------+------------------------+------------------------+-------------+--------------+---------+--+ > | 15012 | Robert | Component Engineer | 1980-06-29 01:31:41.0 | 2067 | NM | 10963 | Component Engineer | 1200001 | 2015-07-13 17:34:48.0 | 2016-09-01 09:13:53.0 | 33691 | 6341805 | 66463 | > | 15013 | Richard | Conference Coordinator | 2010-05-27 13:04:06.0 | 10408 | AL | 76341 | Conference Coordinator | 1300001 | 2015-07-15 07:56:36.0 | 2016-11-25 13:14:17.0 | 61992 | 58731 | 59651 | > | 15027 | Jonathon | Flight Nurse | 1999-05-14 09:17:19.0 | 10635 | MA | 14845 | Flight Nurse | 2700001 | 2015-09-29 23:19:06.0 | 2016-04-28 19:55:40.0 | 57908 | 161869 | 78633 | > | 15010 | Sue | Clinical Reviewer | 2004-01-02 20:04:47.0 | 11623 | IA | 34148 | Clinical Reviewer | 1000001 | 2015-09-16 09:49:18.0 | 2016-03-24 06:31:12.0 | 46362 | 6696935 | 32713 | > | 15011 | Carlos | Commercial Print Management Consultant | 1993-07-03 04:17:06.0 | 20091 | RI | 32071 | Commercial Print Management Consultant | 1100001 | 2015-07-09 04:04:15.0 | 2016-03-13 14:42:45.0 | 19847 | 6654411 | 18747 | > | 15028 | Daniell | Front Desk Agent | 1981-04-19 13:14:14.0 | 20192 | PR | 31469 | Front Desk Agent | 2800001 | 2015-03-08 22:12:39.0 | 2016-12-20 11:59:57.0 | 98291 | 4566010 | 61481 | > | 15020 | Kathryn | Dispatcher | 1981-08-21 04:34:26.0 | 21670 | ME | 2543 | Dispatcher | 2000001 | 2015-11-28 11:17:36.0 | 2016-02-11 23:25:53.0 | 69271 | 5991103 | 20462 | > | 15019 | Donald | Director of Guidance | 1997-05-14 03:26:26.0 | 26266 | NJ | 9497 | Director of Guidance | 1900001 | 2015-03-13 10:10:36.0 | 2016-08-12 10:24:11.0 | 51480 | 9364519 | 98681 | > | 15026 | Tracy | Financial Analyst | 1983-02-03 13:54:06.0 | 30427 | MA | 20044 | Financial Analyst | 2600001 | 2015-09-16 09:10:24.0 | 2016-11-14 11:13:35.0 | 81445 | 8056669 | 73270 | > | 15005 | Charles | Business Intelligence and Reporting Analyst | 2001-07-23 06:15:08.0 | 30606 | CO | 25751 | Business Intelligence and Reporting Analyst | 500001 | 2015-05-11 21:46:33.0 | 2016-03-06 01:02:33.0 | 23012 | 3472846 | 74847 | > | 15040 | Chasity | Licensing Engineer | 2011-04-23 13:12:58.0 | 32224 | ME | 13309 | Licensing Engineer | 4000001 | 2015-07-27 18:36:18.0 | 2016-04-18 07:39:50.0 | 73859 | 9814276 | 76281 | > | 15014 | Richard | Cook | 2006-11-27 16:38:50.0 | 35283 | CT | 26166 | Cook | 1400001 | 2015-12-14 18:03:58.0 | 2016-10-22 14:45:10.0 | 93096 | 2085285 | 25738 | > | 15041 | Jean | Maintenance Worker | 1988-09-07 05:10:45.0 | 38490 | CT | 14294 | Maintenance Worker | 4100001 | 2015-10-25 03:04:58.0 | 2016-02-23 15:03:05.0 | 32161 | 8785660 | 44221 | > | 15030 | Oscar | Global Development Specialist | 2009-10-22 08:35:06.0 | 40125 | MA | 9421 | Global Development Specialist | 3000001 | 2015-09-04 20:19:03.0 | 2016-03-17 12:31:49.0 | 89960 | 3817653 | 75976 | > | 15032 | Salvador | Hardware Designer | 2005-07-03 05:11:58.0 | 40569 | PR | 32763 | Hardware Designer | 3200001 | 2015-08-29 10:25:30.0 | 2016-05-19 15:31:47.0 | 78362 | 2333121 | 14874 | > | 15017 | John | Customer Service Manager | 1980-01-17 20:25:19.0 | 43644 | NH | 22477 | Customer Service Manager | 1700001 | 2015-11-26 02:27:43.0 | 2016-01-19 11:50:50.0 | 22958 | 4563498 | 80010 | > | 15024 | Renee | Estimator | 1996-03-02 23:53:35.0 | 46148 | PA | 17874 | Estimator | 2400001 | 2015-07-20 22:32:51.0 | 2016-02-24 07:00:41.0 | 77737 | 6686138 | 34497 | > | 15033 | Myra | Heavy Equipment Technician | 2005-05-19 10:22:24.0 | 46374 | AL | 89058 | Heavy Equipment Technician | 3300001 | 2015-12-26 03:38:13.0 | 2016-12-18 20:22:46.0 | 8541 | 3715876 | 79511 | > | 15034 | Don | Hotel Deposit Clerk | 1997-10-12 21:51:29.0 | 47043 | MA | 45055 | Hotel Deposit Clerk | 3400001 | 2015-09-09 06:04:25.0 | 2016-05-13 02:30:55.0 | 83165 | 4238937 | 42543 | > | 15009 | Charles | Client Services Coordinator | 2015-06-09 22:54:48.0 | 48995 | ME | 46127 | Client Services Coordinator | 900001 | 2015-02-19 12:15:55.0 | 2016-09-17 22:40:17.0 | 80785 | 8566778 | 52143 | > | 15037 | Tracey | International Consultant | 1996-04-07 23:16:15.0 | 50118 | MO | 39734 | International Consultant | 3700001 | 2015-05-28 22:18:34.0 | 2016-07-31 06:23:26.0 | 76824 | 1795666 | 15594 | > | 15002 | Jamie | Associate Director Social Business Intelligence and Big Data | 2000-01-24 19:52:24.0 | 52799 | MA | 49437 | Associate Director Social Business Intelligence and Big Data | 200001 | 2015-07-13 00:18:29.0 | 2016-02-13 17:38:23.0 | 22018 | 8701972 | 32413 | > | 15043 | Marc | Marketing Operations Analyst | 2001-07-06 11:43:05.0 | 53028 | AL | 36421 | Marketing Operations Analyst | 4300001 | 2015-12-28 21:21:18.0 | 2016-06-06 05:15:26.0 | 93072 | 5762201 | 34924 | > | 15015 | Russell | Crane Operator | 1984-07-30 22:19:30.0 | 53310 | NY | 69460 | Crane Operator | 1500001 | 2015-04-28 11:23:18.0 | 2016-09-22 07:09:17.0 | 35968 | 4205007 | 76615 | > | 15016 | Kyle | Customer Care Associate | 1993-09-15 06:57:44.0 | 53417 | CT | 27247 | Customer Care Associate | 1600001 | 2015-01-15 13:25:55.0 | 2016-11-12 05:23:29.0 | 90622 | 6676968 | 71927 | > | 15031 | Anne | Group Sales Coordinator | 2016-11-19 07:36:41.0 | 53422 | PA | 48029 | Group Sales Coordinator | 3100001 | 2015-04-28 09:10:08.0 | 2016-02-09 15:11:10.0 | 49544 | 859835 | 22933 | > | 15038 | William | Iron Worker | 1988-08-19 00:29:28.0 | 63295 | NJ | 75244 | Iron Worker | 3800001 | 2015-08-06 16:00:15.0 | 2016-06-17 05:19:50.0 | 17574 | 9596126 | 83984 | > | 15042 | Robert | Manufacturing Specialist | 2015-03-07 16:00:21.0 | 63455 | ME | 97823 | Manufacturing Specialist | 4200001 | 2015-05-30 20:49:02.0 | 2016-10-21 09:42:35.0 | 93780 | 2345255 | 89729 | > | 15039 | Hilda | Lawyer | 1982-12-07 10:27:05.0 | 64720 | NJ | 29184 | Lawyer | 3900001 | 2015-06-24 02:12:30.0 | 2016-05-30 15:51:39.0 | 90521 | 5670008 | 62343 | > | 15022 | Diana | Engineering Executive | 1987-03-01 01:49:43.0 | 68841 | MA | 1472 | Engineering Executive | 2200001 | 2015-11-03 11:09:49.0 | 2016-08-16 13:59:51.0 | 57528 | 6144700 | 18606 | > | 15025 | Andrew | Fabricator | 2002-03-24 21:54:43.0 | 69178 | NY | 44637 | Fabricator | 2500001 | 2015-08-26 23:16:31.0 | 2016-03-01 04:02:19.0 | 39833 | 2833348 | 42258 | > | 15023 | Stanley | Environmental Emergencies Assistant | 2010-09-23 03:15:30.0 | 71188 | HI | 29192 | Environmental Emergencies Assistant | 2300001 | 2015-06-12 02:44:16.0 | 2016-03-22 16:09:47.0 | 22824 | 4312759 | 34122 | > | 15018 | Jerry | Data Warehouse and Business Intelligence Developer | 2001-04-22 07:03:45.0 | 72023 | NJ | 73328 | Data Warehouse and Business Intelligence Developer | 1800001 | 2015-05-21 10:06:25.0 | 2016-08-24 15:35:09.0 | 94100 | 5610831 | 79493 | > | 15000 | Juan | Academic Adviser - Athletics | 2008-04-27 19:51:19.0 | 73994 | CO | 40957 | Academic Adviser - Athletics | 1 | 2015-02-16 09:58:47.0 | 2016-03-17 11:55:56.0 | 22197 | 7672248 | 20155 | > | 15008 | Kasandra | Chief Executive Officer | 2013-03-26 22:22:36.0 | 81672 | MA | 34574 | Chief Executive Officer | 800001 | 2015-01-05 11:56:22.0 | 2016-07-08 09:38:00.0 | 65877 | 2281325 | 19142 | > | 15021 | Callie | Educational Travel Sales Representative | 1984-07-26 07:21:57.0 | 82518 | KY | 2047 | Educational Travel Sales Representative | 2100001 | 2015-03-05 09:05:34.0 | 2016-01-20 08:09:02.0 | 47619 | 9520565 | 66597 | > | 15006 | Ted | Call Center Lead | 2007-11-15 14:30:24.0 | 84254 | CT | 25084 | Call Center Lead | 600001 | 2015-11-14 19:55:17.0 | 2016-01-23 07:24:05.0 | 12084 | 1230752 | 96351 | > | 15001 | Inez | Aquatics Director | 1983-09-25 12:34:44.0 | 87985 | CT | 98596 | Aquatics Director | 100001 | 2015-01-16 10:44:33.0 | 2016-10-10 14:10:49.0 | 87916 | 9726989 | 98830 | > | 15004 | Maria | Bilingual Education Assistant | 2016-08-27 01:26:22.0 | 89323 | WV | 93706 | Bilingual Education Assistant | 400001 | 2015-03-14 21:29:22.0 | 2016-02-11 15:34:40.0 | 70405 | 3137845 | 29350 | > | 15007 | Jerry | Catering Sales Manager | 1980-11-23 10:39:34.0 | 90235 | DE | 52352 | Catering Sales Manager | 700001 | 2015-01-25 20:27:41.0 | 2016-02-26 11:25:24.0 | 611 | 8779344 | 23086 | > | 15029 | George | Front Office Attendant | 2004-11-05 12:35:19.0 | 90335 | ME | 22585 | Front Office Attendant | 2900001 | 2015-11-01 10:52:16.0 | 2016-04-19 18:04:06.0 | 50840 | 1956416 | 44585 | > | 15003 | Andrew | Automotive Technician | 2013-03-28 00:15:57.0 | 90436 | AL | 77918 | Automotive Technician | 300001 | 2015-07-25 07:19:59.0 | 2016-01-17 01:50:43.0 | 25338 | 4831471 | 82859 | > | 15035 | Eric | I&C Engineer | 1993-05-12 14:58:18.0 | 90452 | CT | 68410 | I&C Engineer | 3500001 | 2015-06-20 23:36:51.0 | 2016-05-25 15:09:52.0 | 76914 | 6138211 | 17946 | > | 15036 | Shelley | Instructor | 1986-03-31 11:35:03.0 | 94159 | NJ | 74885 | Instructor | 3600001 | 2015-07-20 17:11:27.0 | 2016-09-21 11:35:24.0 | 98138 | 6059721 | 46954 | > +--------+-----------+---------------------------------------------------------------+------------------------+--------------------+------------------------+---------+---------------------------------------------------------------+--------------+------------------------+------------------------+-------------+--------------+---------+--+ > 44 rows selected (0.215 seconds) > Expected Result: It should show 10000 Result instead of 44 rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)