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

Posted by anubhavtarar on Jan 04, 2017; 7:36am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/why-there-is-a-table-name-option-in-carbon-source-format-tp5385p5442.html

ya but if user wanted to create table using carbon session and there is a
option of using tableName it is a kind of bug plus table name in options
also allow to create table with spaces see logs

CREATE TABLE Bug212(int string)USING org.apache.spark.sql.CarbonSource
OPTIONS("bucketnumber"="1", "bucketcolumns"="int","tableName"="t 100");
+---------+--+
| Result  |
+---------+--+
+---------+--+

table t 100 is there in hdfs

this should not happened


On Wed, Jan 4, 2017 at 12:56 PM, Ravindra Pesala <[hidden email]>
wrote:

> you can directly use the other sql create table command like in 1.6.
>
> CREATE TABLE IF NOT EXISTS t3
> (ID Int, date Timestamp, country String,
> name String, phonetype String, serialname char(10), salary Int)
> STORED BY 'carbondata'
>
>
> On 4 January 2017 at 10:02, Anubhav Tarar <[hidden email]>
> wrote:
>
> > exactly my point if table name in create table statement and table name
> in
> > carbon source option is different consider this example
> >
> > 0: jdbc:hive2://localhost:10000> CREATE TABLE testing2(String
> string)USING
> > org.apache.spark.sql.CarbonSource OPTIONS("bucketnumber"="1",
> > "bucketcolumns"="String",tableName=" testing1");
> >
> > then the table which get created in hdfs is testing1 not testing testing2
> > it is quite confusing from user side
> >
> > On Wed, Jan 4, 2017 at 8:33 AM, QiangCai <[hidden email]> wrote:
> >
> > > For Spark 2,  when using SparkSession to create carbon table, need
> > > tableName
> > > option to create carbon schema in store location folder. Better to use
> > > CarbonSession to create carbon table now.
> > >
> > >
> > >
> > > --
> > > 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-tp5385p5420.html
> > > Sent from the Apache CarbonData Mailing List archive mailing list
> archive
> > > at Nabble.com.
> > >
> >
> >
> >
> > --
> > Thanks and Regards
> >
> > *   Anubhav Tarar     *
> >
> >
> > * Software Consultant*
> >       *Knoldus Software LLP <http://www.knoldus.com/home.knol>       *
> >        LinkedIn <http://in.linkedin.com/in/rahulforallp>     Twitter
> > <https://twitter.com/RahulKu71223673>    fb <[hidden email]>
> >           mob : [phone]
> >
>
>
>
> --
> Thanks & Regards,
> Ravi
>

--
Thanks and Regards

*   Anubhav Tarar     *


* Software Consultant*
      *Knoldus Software LLP <http://www.knoldus.com/home.knol>       *
       LinkedIn <http://in.linkedin.com/in/rahulforallp>     Twitter
<https://twitter.com/RahulKu71223673>    fb <[hidden email]>
          mob : [phone]