[ 
https://issues.apache.org/jira/browse/CARBONDATA-2318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16437283#comment-16437283
 ] 

anubhav tarar commented on CARBONDATA-2318:
-------------------------------------------

hi i tried again using same steps that you provided but didn't able to 
replicate the issue

step 1: create carbonsession using sparkshell 
val carbon = SparkSession.builder().config(sc.getConf) 
.getOrCreateCarbonSession("/home/anubhav/Documents/prestostore/data","/home/anubhav/Documents/prestostore/metadata")

step2: copy old carbondata to new store location
/home/anubhav/Documents/carbondata/carbondata/examples/spark2/target/store/default
 to /home/anubhav/Documents/prestostore/data

step3:refresh table
scala> carbon.sql("refresh table carbonsession_table").show
18/04/13 13:43:48 AUDIT CarbonCreateTableCommand: 
[anubhav-Vostro-3559][anubhav][Thread-1]Creating Table with Database name 
[default] and Table name [carbonsession_table]
18/04/13 13:43:49 WARN HiveExternalCatalog: Couldn't find corresponding Hive 
SerDe for data source provider org.apache.spark.sql.CarbonSource. Persisting 
data source table `default`.`carbonsession_table` into Hive metastore in Spark 
SQL specific format, which is NOT compatible with Hive.
18/04/13 13:43:49 AUDIT CarbonCreateTableCommand: 
[anubhav-Vostro-3559][anubhav][Thread-1]Table created with Database name 
[default] and Table name [carbonsession_table]
18/04/13 13:43:49 AUDIT RefreshCarbonTableCommand: 
[anubhav-Vostro-3559][anubhav][Thread-1]Table registration with Database name 
[default] and Table name [carbonsession_table] is successful.

step4:query the new store from presto

./presto-cli-0.187-executable.jar --server localhost:9000 --catalog carbondata 
presto> show tables from default;
 Table 
---------------------
 carbonsession_table 
(1 row)

Query 20180413_080021_00000_vev2q, FINISHED, 1 node
Splits: 18 total, 18 done (100.00%)
0:02 [1 rows, 36B] [0 rows/s, 22B/s]

> Remove invalid table name(.ds_store) of presto integration 
> -----------------------------------------------------------
>
>                 Key: CARBONDATA-2318
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-2318
>             Project: CarbonData
>          Issue Type: Improvement
>          Components: presto-integration
>            Reporter: Liang Chen
>            Priority: Minor
>
> For presto integration , will get the invalid table name via "show tables 
> from default"
> As below.
> presto:default> show tables from default;
>  Table
> --------------------
>  .ds_store
>  carbon_table
>  carbontable
>  partition_bigtable
>  partition_table
> (5 rows)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to