[jira] [Commented] (CARBONDATA-1052) Complete result does not display in Sort_column table.
Locked
[jira] [Commented] (CARBONDATA-1052) Complete result does not display in Sort_column table.
 
|
[ 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) |
«
Return to Apache CarbonData JIRA issues
|
1 view|%1 views
| Free forum by Nabble | Edit this page |