Re: Task Tracker going down on hive cluster

2013-06-12 Thread Rob Roland
I'm not an expert in this, but I do see a Broken pipe writing to a local file system on your task tracker. Is it possible that you're out of disk space, or your EBS volume is failing? S3 doesn't appear to be part of that stack trace. On Wednesday, June 12, 2013, Ravi Shetye wrote: > In last 4-5 o

Re: Issue with creating HIVE metadata for a HBASE table with 2000 + columns

2013-06-10 Thread Rob Roland
You should consult the PostgreSQL documentation: http://www.postgresql.org/docs/9.1/static/sql-altertable.html http://www.postgresql.org/docs/9.1/static/datatype-character.html Essentially, connect to your PostgreSQL instance as a super-user and issue: ALTER TABLE serde_params ALTER COLUMN para

Properly escaping newlines for Hive / HBase

2013-06-06 Thread Rob Roland
TIES ( 'hbase.table.name' = 'blog_post' ); Example query: SELECT * FROM blog_post WHERE blog_name = 'testblog'; Thanks, Rob Roland