Inserting data into cloudera table from excel or other data source

Question

Hi all:

To perform the mentioned task, I've tried to use Data Stream In and Write Data In-DB tools but the problem here is - I've privilege to create table into one specific schema. May be that's the reason why I've encountered error while creating temporary table using Data Stream In. I'd like to know is it possible to insert data directly using Write Data In-DB or using any other tool.

Please help me with your expert advice.

thanks!

tanvir_khan · Answer

Hi @jvansistine:

Thanks a lot for your help.

I've figured it out, there were two drivers installed in the laptop Hive & Tempala. I've changed Hive to Tempala and the problem disappeared.

Thanks!

jvansistine · Answer

I haven't had to write to Cloudera in a while, but maybe these other community articles can provide some guidance?

Uploading with HDFS

Writing to Hive

Good luck!

tanvir_khan · Answer

@jvansistine thanks for the idea mate!

I've tried Output Data tool instead and now data insertion is working. But the only problem I'm facing -data insertion is too slow. Is there anyway to improve this? I mean set any parameter etc.

Thanks!