[
https://issues.apache.org/jira/browse/CARBONDATA-1052?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pallavi Singh reassigned CARBONDATA-1052:
-----------------------------------------
Assignee: Pallavi Singh
> 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
> Assignee: Pallavi Singh
> 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)
