Re: Textfile compression using Gzip codec

2013-06-05 Thread Stephen Sprague
well... the hiveException has the word "metadata" in it. maybe that's a hint or a red-herrring. :)Let's try the following: 1. show create table * facts520_normal_text; * *2. anything useful at this URL? ** http://aana1.ird.com:50030/taskdetails.jsp?jobid=job_201306051948_0010&tipid=task_

External Tables - how to define the file name for data storage

2013-06-05 Thread Richa Sharma
Hi Can i control the actual file name in which data is stored in an external table in Hive ? In Hive I want to load data from table A into an external table B and then using Pig access data in table B. Right now data is stored in file name 0_0 -- I want to give it a definite way. is there a

Textfile compression using Gzip codec

2013-06-05 Thread Sachin Sudarshana
Hi, I have hive 0.10 + (CDH 4.2.1 patches) installed on my cluster. I have a table facts520_normal_text stored as a textfile. I'm trying to create a compressed table from this table using GZip codec. *hive> SET hive.exec.compress.output=true;* *hive> SET mapred.output.compression.codec=org.apach