The query result of the imported file created in the hive table is null.

Source: Internet
Author: User
Tags file separator

When creating a table, hive will specify a delimiter. For example, it is set to tab to separate attribute columns \ n to separate records.


However, if the format of the document we uploaded is not as follows, the record is saved but the query result is indeed a column of null.

The format of the TXT file to be uploaded, but the column spacing is indeed separated by spaces. Therefore, no accurate records can be found.


There are two solutions:

1. When creating a table, set the table according to the file separator and modify the fields and lines delimiters. For example, replace the \ t of the first graph with spaces.

2. Modify the file separator. For example, use tab to separate the data in each column of the second graph.

Suggestion: Change the text separation format because the default delimiter of the Database Text import column is tab.

If you use MySQL to import local files, if the columns are separated by spaces, only the first field can be filled.

The query result of the imported file created in the hive table is null.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.