Method used to create a Hive table using multi-character delimiters

In most cases, a carriage return character is used as the row delimiter in Hive tables stored in text files, that is, the carriage return character is used as the terminator of a row during search. However, some data files are delimited by special characters other than a carriage return character. FusionInsight Hive allows you to use different characters or character combinations to delimit rows of Hive text data. When creating a table, set inputformat to SpecifiedDelimiterInputFormat, and set hive.textinput.record.delimiter='' before search each time. Then the table data is queried by the specified delimiter.

Scroll to top