Re: Int accepting range of BigInt

2016-12-26 Thread Kumar Vishal
Hi Anurag, Carbon has value based compression for storing the measure column data, in store it will be stored as int. I think only the bug is in desc table as we are updating the data type in schmea. My query is that to resolve the issue of out of range values being accepted for Int, should we be

Re: Int accepting range of BigInt

2016-12-26 Thread Anurag Srivastava
Hello Raghu, We can not validate data on the basis of schema because when we give "Int" data type it stores in schema as a "BigInt" data type and then it starts taking range of "BigInt". When we provide "BigInt" data type, it also stores as a "BigInt". That time it will not be possible to

Re: Int accepting range of BigInt

2016-12-26 Thread Raghunandan S
Dear anurag, Not required to be stored as int.if we validate the data based on the schema definition would suffice On Mon, 26 Dec 2016 at 1:10 PM, Anurag Srivastava wrote: > Hello everyone, > > I am working on resolving jira bug >

Re: Int accepting range of BigInt

2016-12-25 Thread Anurag Srivastava
Hello everyone, I am working on resolving jira bug https://issues.apache.org/jira/browse/CARBONDATA-370 While resolving this I found that when I create a table with Int as one of the columns and then if I do Desc table, it shows the Int column being created as BigInt :- So, the Int column is

Re: Int accepting range of BigInt

2016-11-04 Thread Anurag Srivastava
Please find Image. ​ On Fri, Nov 4, 2016 at 1:31 PM, Pallavi Singh wrote: > > ​ > > On Fri, Nov 4, 2016 at 1:28 PM, Sangeeta Gulia > wrote: > >> Please find the image attached. >> >> On Fri, Nov 4, 2016 at 1:24 PM, Pallavi Singh

Re: Int accepting range of BigInt

2016-11-04 Thread Sangeeta Gulia
Please find the image attached. On Fri, Nov 4, 2016 at 1:24 PM, Pallavi Singh wrote: > Please find the image as an attachment > > On Thu, Nov 3, 2016 at 11:06 PM, Kumar Vishal > wrote: > >> Hi Pallavi, >>Currently in carbon

Re: Int accepting range of BigInt

2016-11-04 Thread Pallavi Singh
Please find the image as an attachment On Thu, Nov 3, 2016 at 11:06 PM, Kumar Vishal wrote: > Hi Pallavi, >Currently in carbon int data type is stored as big int. Can > u please re-upload the image. > > -Regards > Kumar Vishal > > On Thu, Nov 3, 2016

Re: Int accepting range of BigInt

2016-11-04 Thread Pallavi Singh
[image: Inline image 1] please find the image you requested for. On Thu, Nov 3, 2016 at 11:06 PM, Kumar Vishal wrote: > Hi Pallavi, >Currently in carbon int data type is stored as big int. Can > u please re-upload the image. > > -Regards > Kumar Vishal

Re: Int accepting range of BigInt

2016-11-04 Thread manish gupta
Hi Pallavi, This is a bug in the system. We store Int as bigInt but value beyond the integer range should not be allowed for storage in integer datatype column. >From my opinion you can raise a Jira issue for this. Regards Manish Gupta On Thu, Nov 3, 2016 at 11:06 PM, Kumar Vishal

Re: Int accepting range of BigInt

2016-11-03 Thread Kumar Vishal
Hi Pallavi, Currently in carbon int data type is stored as big int. Can u please re-upload the image. -Regards Kumar Vishal On Thu, Nov 3, 2016 at 10:09 AM, Pallavi Singh wrote: > Hi, > > I would like to know when we execute the query : > create table

Int accepting range of BigInt

2016-11-02 Thread Pallavi Singh
Hi, I would like to know when we execute the query : create table employee(id int, name String) stored by 'carbondata'; the table created is : [image: Inline image 1] the Int is converted into BigInt and Int supports range beyond (-2147483648 to 2147483647) -- Regards | Pallavi Singh