Dears, I successfully used the below commands and the string, that has comma  "," within it, is quoted by double quotes; I need please to use single quotes so the result will be '2,3' not "2,3".   $export HADOOP_CLIENT_OPTS="-Ddisable.quoting.for.sv=false" $ beeline -u 'jdbc:hive2://localhost:10000/' --outputformat=csv2 -e "select 1 as a, '2,3' as b"   a ,    b 1 , "2,3"   regards, Omran Badarneh ... View more

Dear Gents,   How to use extended Screen during Cloudera exams;  I have submitted CCA159 exam but I faced a problem that I have to jump between screen. I have extend screen; Can I use it to see  always the questions?? please how ?? ... View more

Dear Gents, I am using Cloudera QuickStart (CDH 5.13.0, Packages) I have created  JAVA UDF function named omlower as test case for HIVE UDF using JAVA. but it is not working and return this error  "Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask" I used these steps 1- Create omlower.java file with this content package com.example.hive.udf; import org.apache.hadoop.hive.ql.exec.UDF; import org.apache.hadoop.io.Text; public final class omlower extends UDF { public Text evaluate(final Text s) { if (s == null) { return null; } return new Text(s.toString().toLowerCase()); } }   2- compile is succesfully using [cloudera@quickstart ~]$ javac omlower.java -cp $(hadoop classpath)   3- create Jar file using [cloudera@quickstart ~]$ jar -cvf omlower.jar omlower.class -cp $(hadoop classpath)   4- copy JAR file to HDFS directory /user 5- using HUE UI and HIVE editor , I tried to create UDF Function CREATE FUNCTION omlower AS 'com.example.hive.udf.omlower' USING JAR 'hdfs:/user/omlower.jar'; but it gives this error "Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask" any help please   Regards Omran   ... View more