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)
