Load data from Drill table into Hive Table

Question

I have created a table using Drill and it is located at

/user/abc/drill/Drilltable.

Now I would like to load the data from DrillTable into HiveTable which is located at path

/user/hive/warehouse/userxyz.db

I am using below statement to load data

INSERT INTO TABLE HiveTable select *  from DrillTable;

I get the error

Table not found

and I am bit confused how to let Hive know the path of Drill table.

What would be the right way to handle this?

score 0 · Answer 1 · answered Nov 17 '18 at 18:39

Hive might be confused about the schema of the drill data as well as the location. If you're willing to experiment, try something like this:

Store the data in a Drill format you can model in Hive, CSV for example, as described in this post.
In Hive, create an external table that defines the schema and location of the textual data. You can then convert the external table to a managed table (optional). For example ....

1 Answers1