percentile function in impala
Hi, I have a table on hbase i want to query on impala to calculate 95 th and 99 th percentile? any built in function available or user defined function?
Re: percentile function in impala
Impala currently doesn't have percentile functions. Work on those is tracked in IMPALA-3602 and contributions are always welcome. You might be able to get what you need using analytic functions, e.g. NTILE: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_analytic_functions.html#ntile On Tue, Aug 29, 2017 at 8:39 AM, Gayathri Devi wrote: > Hi, > > I have a table on hbase i want to query on impala to calculate 95 th and 99 > th percentile? any built in function available or user defined function? >
Compile error in Redhat 7.x
Hi, I try to compile impala in Red Hat Enterprise Linux Server release 6.5 (Santiago), and I get thje error : cmake: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/lib64/libstdc++.so.6) cmake: /lib64/libc.so.6: version `GLIBC_2.18' not found (required by /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/lib64/libstdc++.so.6) cmake: /lib64/libc.so.6: version `GLIBC_2.17' not found (required by /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/lib64/libstdc++.so.6) cmake: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/lib64/libgcc_s.so.1) Error in /home/hzfengyu/source/impala-kudu/bin/make_impala.sh at line 125: cmake . ${CMAKE_ARGS[@]} Error in buildall.sh at line 319: "$IMPALA_HOME/bin/make_impala.sh" ${MAKE_IMPALA_ARGS} change GLIBC have a great influence, So do I have any other way finish it. I just want to compile and run impala cluster beyond Red Hat Enterprise Linux Server release 6.5 . Thanks a lot.
Re: Compile error in Redhat 7.x
Impala definitely should build and run on RHEL6.x. We do most of our testing on CentOS 6. I'm not sure if this will help, but when building on Ubuntu we generally need to set LD_LIBRARY_PATH to work around this problem export LD_LIBRARY_PATH=/usr/lib/x86_64-linux-gnu/:$LD_LIBRARY_PATH On Tue, Aug 29, 2017 at 8:15 PM, yu feng wrote: > Hi, I try to compile impala in Red Hat Enterprise Linux Server release 6.5 > (Santiago), and I get thje error : > > cmake: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by > /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/ > lib64/libstdc++.so.6) > cmake: /lib64/libc.so.6: version `GLIBC_2.18' not found (required by > /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/ > lib64/libstdc++.so.6) > cmake: /lib64/libc.so.6: version `GLIBC_2.17' not found (required by > /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/ > lib64/libstdc++.so.6) > cmake: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by > /home/hzfengyu/source/impala-kudu/toolchain/gcc-4.9.2/lib64/libgcc_s.so.1) > Error in /home/hzfengyu/source/impala-kudu/bin/make_impala.sh at line 125: > cmake . ${CMAKE_ARGS[@]} > Error in buildall.sh at line 319: "$IMPALA_HOME/bin/make_impala.sh" > ${MAKE_IMPALA_ARGS} > > change GLIBC have a great influence, So do I have any other way finish it. > > I just want to compile and run impala cluster beyond Red Hat Enterprise > Linux Server release 6.5 . > > Thanks a lot. >