You can load a CSV or TSV file directly into a table in Heavy Immerse. HEAVY.AI supports Latin-1 ASCII format and UTF-8. If you want to load data with another encoding (for example, UTF-16), convert the data to UTF-8 before loading it to HEAVY.AI.
Loading Data with Apache Kafka
You can load data files into HeavyDB using Apache Kafka from the command line. See Inserting Data Using Kafka.