I have been trying to upload a Wikipedia clickstream file into a Hive table with no luck.
I am using a recently downloaded HDP Sandbox. After doing some file upload/table create ops with good luck, I thought I'd go for a big one.
The file is 1.2 GB and is tab-separated, and the preview wouldn't work. So I converted it to comma-separated with double-quotes.
From the Files view, I uploaded the file into a new folder as maria_dev and set permissions to rw-rw-rw-.
In Hive 2.0, I created a new database and tried several times to create table by upload from that file. The preview picks up the columns without trouble.
Every time I try to hit 'create' it goes through the usual steps, then end with 'deleting live table 2016_03_en_clickstream.csv'
?? what ??
I get a message "missing translation: uploadFromHdfs" but I think this is a red herring.
The job log shows creating the gibberish-name temp table, then deleting it, then deleting the table.
Can someone clue me in here?