Need tab separated output file and put limit on number of lines in a output file

2013-02-19 Thread Chunky Gupta
Hi, Currently the output file columns of my query is separate by "^A", I need my output to be separated by tab. Can anybody help me in setting this ? I more doubt, I want to limit the number of lines in output files. For example, I do not want any of my output file to be more than 1000 lines, can

Re: hive-0.10 and nullpointerexception

2013-02-19 Thread Mark Grover
Hey Marcin, Sorry I haven't gotten a chance to look into this further. I am fairly certain that it's a bug in Utilities.java which HIVE-4003 is going to fix. I am have been trying to reproduce the behavior locally with trunk but so far, have been unsuccessful in doing so. In any case, so it boils

Re: NULLable STRUCTs

2013-02-19 Thread Michael Malak
If no one has any objection, I'm going to update HIVE-4022, which I entered a week ago when I thought the behavior was Avro-specific, to indicate it actually affects even native Hive tables. https://issues.apache.org/jira/browse/HIVE-4022 --- On Fri, 2/15/13, Michael Malak wrote: > From: Mich

Re: Using Reflect: A thread for ideas

2013-02-19 Thread Edward Capriolo
We could very easily write hive so that a UDF is a piece of groovy loaded dynamically. This is my go-to system to make things plugable. On Tue, Feb 19, 2013 at 10:03 AM, John Meagher wrote: > Another option for this functionality would be to use the Java scripting > API. The basic structure of t

Re: Using Reflect: A thread for ideas

2013-02-19 Thread John Meagher
Another option for this functionality would be to use the Java scripting API. The basic structure of the call would be... select script( scriptLanguage, scriptToRun, args... ) I haven't seen that in Hive, but something similar is available for Pig. Documentation for that is available on http://

Re: hive-0.10 and nullpointerexception

2013-02-19 Thread Marcin Cylke
On 14/02/13 08:27, Marcin Cylke wrote: > Actually I'm not using YARN, just the classic MR. Perhaps the setting is > somewhere in my configuration? My whole cluster is running MR1. Since > I'm running Cloudera cdh4.1 I'm starting hive with the following line: > > HADOOP_MAPRED_HOME=/usr/lib/hadoop