Create HIVE Table with multi character delimiter

by

FILELDS TERMINATED BY does not support multi-character delimiters. The easiest way to do this is to use RegexSerDe:

CREATE EXTERNAL TABlE tableex(id INT, name STRING) 
ROW FORMAT 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
WITH SERDEPROPERTIES (
  "input.regex" = "^(\\d+)~\\*(.*)$"
)
STORED AS TEXTFILE 
LOCATION '/user/myusername';

More Related Contents:

  1. What is the difference between partitioning and bucketing a table in Hive ?
  2. Difference between Hive internal tables and external tables?
  3. How to transpose/pivot data in hive?
  4. Sqoop import : composite primary key and textual primary key
  5. How to delete and update a record in Hive
  6. Hive unable to manually set number of reducers
  7. How to update table in Hive 0.13?
  8. how many mappers and reduces will get created for a partitoned table in hive
  9. Hive: Add partitions for existing folder structure
  10. How to load data to hive from HDFS without removing the source file?
  11. Loading Data from a .txt file to Table Stored as ORC in Hive
  12. Job queue for Hive action in oozie
  13. Difference between Pig and Hive? Why have both? [closed]
  14. What is Hive: Return Code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
  15. Can Hive recursively descend into subdirectories without partitions or editing hive-site.xml?
  16. Hive Data Retrieval Queries: Difference between CLUSTER BY, ORDER BY, and SORT BY
  17. How do I output the results of a HiveQL query to CSV?
  18. Set hadoop system user for client embedded in Java webapp
  19. Spark on yarn concept understanding
  20. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
  21. OOZIE: properties defined in file referenced in global job-xml not visible in workflow.xml
  22. How to get the input file name in the mapper in a Hadoop program?
  23. hadoop map reduce secondary sorting
  24. Apache Spark: The number of cores vs. the number of executors
  25. Where are logs in Spark on YARN?
  26. Where does hadoop mapreduce framework send my System.out.print() statements ? (stdout)
  27. Default Namenode port of HDFS is 50070.But I have come across at some places 8020 or 9000 [closed]
  28. Hadoop input split size vs block size
  29. Difference between HBase and Hadoop/HDFS
  30. Merging multiple files into one within Hadoop

Leave a Comment