Hive is a data warehouse framework built on Hadoop. It provides storage of structured data using the Hive query language (HQL), a language like the SQL. Hive converts HQL statements to MapReduce or HDFS tasks for querying and analyzing massive data stored in Hadoop clusters. The console provides the interface for entering Hive SQL commands and supports online HQL statement submission
Hive supports encryption of one or more columns. Columns to be encrypted and the encryption algorithm can be specified when a Hive table is created. When data is inserted into the table using the insert statement, the related columns are encrypted.
The Hive column encryption mechanism supports two encryption algorithms, which can be selected to meet site requirements during table creation:
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.
MRS 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 the following parameter before search each time. Then the table data is queried by the specified delimiter.
Comma separated value (CSV) is a common text file format. CSV stores table data (digits and texts) in texts and uses a comma (,) as the text delimiter.
CSV files are universal. Many applications allow users to view and edit CSV files. CSV files can be used in Windows Office or conventional databases.
MRS Hive supports CSV files. You can import user CSV files to Hive tables or export user Hive table data as CSV files to use them in other applications.