You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Vinod Rohilla (JIRA)" <ji...@apache.org> on 2017/05/15 07:59:04 UTC
[jira] [Created] (CARBONDATA-1052) Complete result does not display
in Short_column table.
Vinod Rohilla created CARBONDATA-1052:
-----------------------------------------
Summary: Complete result does not display in Short_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
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)