carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vinod Rohilla (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CARBONDATA-1052) Complete result does not display in Short_column table.
Date Mon, 15 May 2017 07:59:04 GMT
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)

Mime
View raw message