Hi Lefty,
The Hive aggregate functions as you provide just states:
DOUBLE
stddev_pop(col)
Returns the standard deviation of a numeric column in the group.
DOUBLE
stddev_samp(col)
Returns the unbiased sample standard deviation of a numeric column in the group.
There is no mention
Hi Lefty,
ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java:
system.registerGenericUDAF(stddev, new GenericUDAFStd());
ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java:
system.registerGenericUDAF(stddev_pop, new GenericUDAFStd());
I use hive 0.14 the result is
87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 9150119100048
7326356 NULL
87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 121501191035580028
7326356 NULL
UBDTK8D9XUZ9GRZU8NZNXDEG73D4PCZG2362223711289
Can you also supply the table's DDL and a few lines of your raw data?
Daniel
On 1 באפר׳ 2015, at 09:16, r7raul1...@163.com r7raul1...@163.com wrote:
I use hive 0.14 the result is
87FQEZT1UEDXJHJQPFFX7G7ET8S2DVPM2357378283356 9150119100048
7326356 NULL
Mich, the linked documentation is for Impala, not Hive. (Perhaps Hive is
the same, I don't know.) But the Hive documentation doesn't explain
much: Built-in
Aggregate Functions (UDAF)
Hi Alan,
Regarding the streaming changes, I've raised an issue and submitted patches
here: https://issues.apache.org/jira/browse/HIVE-10165
Thanks - Elliot.
On 26 March 2015 at 23:20, Alan Gates alanfga...@gmail.com wrote:
Elliot West tea...@gmail.com
March 26, 2015 at 15:58
Hi Alan,
Hi,
I'm attempting to write a ReaderReader and RecordWriter for ORC that
support reading and writing String for HiveChar and HiveVarchar and
BigDecimal for HiveDecimal to simplify usage a little - I need Serializable
types.
To do this I've gone the ObjectInspector route, eg:
... extends
Hi,
I'm a relatively new user to Hive and was trying to format a column of
String datatype from Uppercase to Camel-case. I could see the INITCAP()
function in the language manual, and also could find related notes on JIRA
stating it is available. But for some reason when I run my query it shows
Available in build 1.1.0
https://issues.apache.org/jira/browse/HIVE/fixforversion/12329363
JIRA : https://issues.apache.org/jira/browse/HIVE-3405
Regards
Sanjiv Singh
Mob : +091 9990-447-339
On Wed, Apr 1, 2015 at 6:24 PM, vivek veeramani vivek.veeraman...@gmail.com
wrote:
Hi,
I'm a
Hi All,
I am new to Hive. Just set up a 5 nodes Hadoop environment and want to have
a try on HiveQL.
Is there any dataset I can download to play HiveQL. The dataset should have
several tables some I can write some complex join. About 100G should be
fine.
Thanks,
Xiaohe
Hi Xiaohe,
If it's data set that you're looking for, you can find wikipedia data dumps
@ http://dumps.wikimedia.org/enwiki/. Also documentation on the dumps @
http://meta.wikimedia.org/wiki/Data_dumps.
Hope this helps..
On Thu, Apr 2, 2015 at 10:56 AM, xiaohe lan zombiexco...@gmail.com wrote:
Thank you Sanjiv. I've reached out to our Infrastructure vendor to check
what build we're on currently and if we can get the 1.1.0 version. But was
just curious to know, is there a way we can see the build version?
Thanks,
Vivek
On Wed, Apr 1, 2015 at 7:14 PM, @Sanjiv Singh
I can suggest 3 options
1. you can use JUnit test to test your UDF (e.g. TestGenericUDFLastDay)
2. you can create q file and test your UDF via mvn (look at udf_last_day.q)
mvn clean install -DskipTests -Phadoop-2
cd itest/qtest
mvn test -Dtest=TestCliDriver -Dqfile=udf_last_day.q
Hi,
I'm developing a new UDF.
I want to be able to test the new jar as I develop without having to copy
the Jar up to HDFS every time I change code and recompile the Jar.
I'm using Hive CLI for testing, and adding this command:
add jar 'file:///home/abohr/test/hive-udf-1.0-SNAPSHOT.jar';
I've
Vivek,
You can see the version in two places
1.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions
stringinitcap(string A)Returns string, with the first letter of
each word in uppercase, all other letters in lowercase. Words are
15 matches
Mail list logo