Re: why there is a table name option in carbon source format?

[anubhavtarar]

and my question for this post is that if i use carbonsource and create table
like this

CREATE TABLE Bug211(int int)USING org.apache.spark.sql.CarbonSource
OPTIONS("bucketnumber"="1", "bucketcolumns"="String","tableName"="t 100");

here table t 100 is created in hdfs if tablename and defaulttablename is
different and even second thing how can table name have spaces t 100



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/why-there-is-a-table-name-option-in-carbon-source-format-tp5385p5467.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.

Re: carbon thrift server for spark 2.0 showing unusual behaviour

[anubhavtarar]

have a look at these logs 

CREATE TABLE Bug212(int string)USING org.apache.spark.sql.CarbonSource
OPTIONS("bucketnumber"="1", "bucketcolumns"="String","tableName"="t100");

Error:
org.apache.carbondata.spark.exception.MalformedCarbonCommandException: Table
default.t 100 can not be created without key columns. Please use
DICTIONARY_INCLUDE or DICTIONARY_EXCLUDE to set at least one key column if
all specified columns are numeric types (state=,code=0)

2 minutes later

 CREATE TABLE Bug211(int int)USING org.apache.spark.sql.CarbonSource
OPTIONS("bucketnumber"="1", "bucketcolumns"="String","tableName"="t 100");

CREATE TABLE Bug211(int int)USING org.apache.spark.sql.CarbonSource
OPTIONS("bucketnumber"="1", "bucketcolumns"="String","tableName"="t 100");

it is blocking for spark2




--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/carbon-thrift-server-for-spark-2-0-showing-unusual-behaviour-tp5384p5444.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.

carbon shell is not working with spark 2.0 version

[anubhavtarar]

carbon shell is not working with spark 2.0 version
here are the logs

java.lang.ClassNotFoundException: org.apache.spark.repl.carbon.Main
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at org.apache.spark.util.Utils$.classForName(Utils.scala:225)
at
org.apache.spark.deploy.SparkSubmit$.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:686)
at
org.apache.spark.deploy.SparkSubmit$.doRunMain$1(SparkSubmit.scala:185)
at
org.apache.spark.deploy.SparkSubmit$.submit(SparkSubmit.scala:210)
at org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit.scala:124)
at org.apache.spark.deploy.SparkSubmit.main(SparkSubmit.scala)



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/carbon-shell-is-not-working-with-spark-2-0-version-tp5436.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.

why there is a table name option in carbon source format?

[anubhavtarar]

why there is table name option in carbon source format when we are alreday
giving table name with create table command

here are the logs
0: jdbc:hive2://localhost:1> CREATE TABLE testing2(String string)USING
org.apache.spark.sql.CarbonSource OPTIONS("bucketnumber"="1",
"bucketcolumns"="String",tableName=" ");



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/why-there-is-a-table-name-option-in-carbon-source-format-tp5385.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.

carbon thrift server for spark 2.0 showing unusual behaviour

[anubhavtarar]

carbon thrift server is not parsing carbon query randomly with spark 2

here are the logs

: jdbc:hive2://localhost:1> CREATE TABLE Bug221755915(int int)USING
org.apache.spark.sql.CarbonSource;
+-+--+
| Result  |
+-+--+
+-+--+
No rows selected (0.216 seconds)

can anyone help?




--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/carbon-thrift-server-for-spark-2-0-showing-unusual-behaviour-tp5384.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.

Bucket Table Queries

[anubhavtarar]

i am working for testing of bucket table and its join optimization but pr for
that is still not merged looking at pr CARBONDAT-467 i only get familiar
with create table command i want to know the query for load,alter and join
in bucketing table can anyone help 



--
View this message in context: 
http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Bucket-Table-Queries-tp5199.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at 
Nabble.com.