- upload the file to Linux and then pass it to HDFS
hadoop fs -put 1.csv /
- enter the shell command of hbase and create hbase table
create 'amazon_key_word','MM'
- import data by command
format: hbase [class] [separator] [row key, column family] [table] [import file]
hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator="," -Dimporttsv.columns=HBASE_ROW_KEY,MM:dept,MM:search_word,MM:Search_ranking,MM:asin,MM:name,MM:click_v,MM:conversion,MM:asin2,MM:name2,MM:click_v2,MM:conversion2,MM:asin3,MM:name3,MM:click_v3,MM:conversion3 amazon_key_word /1.csv
Note that the first column data is hbase rowkey
Read More:
- Pandas read the CSV file error filenotf oundError:File b ‘***.csv’ does not exist
- python reads csv file is an error _csv.Error: iterator should return strings, not bytes (did you open the file in text)
- No code, a solution to the error in the path of reading CSV file by Python: filenotfounderror: [errno 2] no such file or directory: ‘XX. CSV‘
- [Solved] Import org.apache.hadoop.hbase.hbaseconfiguration package cannot be imported
- hbase ERROR org.apache.hadoop.hbase.PleaseHoldException: Master is initializing
- The list command in HBase shell reported an error org.apache.hadoop . hbase.PleaseHoldException : Master is initializing
- Neo4j LOAD CSV Error: Query cannot conclude with LOAD CSV
- When reading the CSV file with Python 3, the Unicode decodeerror: ‘UTF-8’ codec can’t decode byte 0xd0 in position 0: invalid con appears
- Import / export. SQL file / gzip file for MySQL under Linux
- How to Solve Hbase Error: Master is initializing
- Some problems in the development of HBase MapReduce
- Python export data (CSV format)
- An error occurs when HBase uses the shell command: pleaseholdexception: Master is initializing solution
- Java query HBase outoforderscannernextexception
- sqoop-import ERROR tool.ImportTool: Import failed: No primary key could be found for table user_info
- Navicat import local SQL file error “[MSG] finished – unsuccessfully | [err] 1046 – no database selected”
- Import Maven project pom.xml File error
- Solution of server not running yetexception in HBase
- ERROR: KeeperErrorCode = NoNode for /hbase/master
- HBase checkandput() method