Create table like old table.

2016-10-19 Thread prabhatkashyap
Hello I'm trying to create a table like my old table but it is not creating
as expected.



Above one is my *mainTable* and I wants to create *copiedTable* from it but
everytime it is show something like:






--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Create-table-like-old-table-tp2037.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.


Unable to perform compaction,

2016-10-20 Thread prabhatkashyap
Hello,
There is some issue with compaction. Auto and force compaction are not
working.
In spark logs I got this error:









--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Unable-to-perform-compaction-tp2099.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.


Re: No error on executing 'IN' operator without specifying any columnname

2016-11-01 Thread prabhatkashyap
When ever I'm trying to run following command in HIVE:

it executes normally in HIVE, but the same query gives the following error
in CARBONDATA :



Please confirm is it Carbon Data bug or Spark one. 



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/No-error-on-executing-IN-operator-without-specifying-any-column-name-tp2424p2485.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.


Multiple arguments in count function.

2016-11-01 Thread prabhatkashyap
I am able to use multiple column name and even asterisk with columns in count
function. Even though it is giving me correct output but I think it should
not be allowed.



As the same queries give error when executed in HIVE. 

Please confirm.



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Multiple-arguments-in-count-function-tp2487.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.


No error on executing 'IN' operator without specifying any column name

2016-10-28 Thread prabhatkashyap
Hello,

I've tried to use the following query in carbon data and hive :



While executing it on carbon data it gave me output of "/No row selected/"
but I think there should be an exception/error. whereas when executed in
Hive it gave me parse exception:



Please confirm.

Thanks




--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/No-error-on-executing-IN-operator-without-specifying-any-column-name-tp2424.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.


Re: Unable to perform compaction,

2016-10-26 Thread prabhatkashyap
Hi Liang,

Sorry for the late reply, 

*For auto compaction:*

I've set my default threshold for compaction and set 


and for force compaction I've used the *ALTER* Query



But on both of the cases it is showing me error






--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Unable-to-perform-compaction-tp2099p2349.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.


Ambiguous behavior of Joins with ON clause

2016-11-04 Thread prabhatkashyap
Hello, 

When ever I'm trying to run following query
 
it executes successfully.

But when I m trying to run :

It gave error 


Similarly 

Is working but

Not working

Please confirm.



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Ambiguous-behavior-of-Joins-with-ON-clause-tp2632.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.