Support Questions
Find answers, ask questions, and share your expertise

The scoop update query

The scoop update query

Explorer

Dear Madam,

How to import text data in scoop 

The updated rows or the count is mismatched 

1 REPLY 1

Re: The scoop update query

Contributor

Hello @Rak,

 

Can you please share the exact sqoop command you are running at your end.

 

If you have the table in Textformat and you are getting more number of rows in Hive in comparison to source, this means your data from Source contains change line characters such as "\n" or other special characters, in some of your fields.

 

To resolve the issue, import the data to an ORC Hive table.

Example on how to create ORC table in Hive:

 

CREATE TABLE TEST_ORC(
Id INT,
Name STRING) STORED AS ORC;

 

If you do not want to store the data to ORC table, you can move the data from the ORC table to TextFormat table later within Hive.