pingcap
Can't Create table use CTAS and CreateTable Like
Bug 报告
When I wan't to use TiSpark and Hive together, It's OK to read data from hive and TiKV, but it failed to Create table into TiKV. I have seen the code of Ti Spark, it show's that your have write a Command of Create table like, but it don't works.
-
What is the document directory for the problem?
-
How would you like to improve it? When use hive and tispark together, we can create table in TiKV
Hi, @AngersZhuuuu.
As you can see, TiSpark has not yet implemented create table like statement to create TiKV tables. The current create table like statement will try to create the table in Hive.
The error you are observing is due to the fact that your catalog in Hive is on database default, and it already contains a table called test_ctas. We will support this feature later. In order to do so, we will provide an API such as create tikv table like or create tikv table select. You may keep track on this issue for this progress.
Meanwhile you can also use DataSource API to create a DataFrame and insert into TiKV, which you may refer to this document. Or you may as well use JDBC connector to run your statement.
