Cloudera Community
vratmuri
user rank
Contributor
My Accepted Solutions
Show All

Re: Create Hive Table from JSON Files

by Contributor in Support Questions
‎08-02-2018 06:58 AM
‎08-02-2018 06:58 AM
David @David M.,   Actually, I'm looking to get the Impala logs with a querytext, start time, end time, memory, username, etc.... for tracking the user queries and to create the live dashboards like Cloudera Navigator but with free of cost.   We have Spark or UDF to create the table from JSON in Hive.   >>> df = sqlContext.read.json ("/user/venkata/lineage.json") >>> df.saveAsTable("secure.lineage")   Thanks, Venkat ... View more

Re: Create Hive Table from JSON Files

by Contributor in Support Questions
‎08-02-2018 05:28 AM
‎08-02-2018 05:28 AM
Saranvisa @saranvisa,   Thanks for the reply.   Not just for one time. Export is just manually thing but I would like to do streaming.   In my cluster, the minimum Impala queries : 300queries/30mints. huge. So....     Thanks, Venkat ... View more

Re: Create Hive Table from JSON Files

by Contributor in Support Questions
‎08-01-2018 12:23 PM
‎08-01-2018 12:23 PM
Kumar @Venkatesh_Kumar,    How did you get the IMPALA query report? I'm trying to download the Impala queries, So Could you help me.   Is there any location or way to download it?   I found the /var/log/impalad/lineage/ location for logs but I'm not able to stream those logs to table.   Thanks, Venkat. ... View more

Re: Hive update , delete and insert ERROR in cdh 5...

by Contributor in Support Questions
‎06-13-2018 01:04 PM
‎06-13-2018 01:04 PM
It's problem with hive server. Please run UPDATE or DELETE commands on a Client machine or update the below set commands on Hive-stie.xml file. SET hive.support.concurrency = true; SET hive.enforce.bucketing = true; SET hive.exec.dynamic.partition.mode = nonstrict; SET hive.txn.manager =org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; SET hive.compactor.initiator.on = true; SET hive.compactor.worker.threads = 1; ... View more

Re: HIVE UDF jar_ Error ST_Point _ GIS ESRI

by Contributor in Support Questions
‎03-23-2018 07:34 AM
‎03-23-2018 07:34 AM
Solved.Problem with Sentry. ... View more

Re: PostgreSQL Cloudera Management Service Embedde...

by Contributor in Support Questions
‎01-17-2018 12:54 PM
‎01-17-2018 12:54 PM
Thank you @saranvisa Thank you @Divyani ... View more

PostgreSQL Cloudera Management Service Embedded Da...

by Contributor in Support Questions
‎01-15-2018 06:11 AM
‎01-15-2018 06:11 AM
  Hi, I have a problem with storage space in Cloudera.   I'm using AWS services for PostgreSQL and AWS says free space is 96GB out of 100GB.     Could anyone help to increase PostgreSQL database storage space for Cloudera Management Services?        #CDH 5.10.1 #PostgreSQL 9.5.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16), 64-bit   Thanks, Venkat.   ... View more
Labels:

HIVE UDF jar_ Error ST_Point _ GIS ESRI

by Contributor in Support Questions
‎11-07-2017 01:37 PM
1 Kudo
‎11-07-2017 01:37 PM
1 Kudo
Hi, When I'm trying to create a geometric consultation with ST_Point.   add jar esri-geometry-api-1.1-sources.jar; add jar esri-geometry-api-1.1.jar; add jar spatial-sdk-hadoop.jar; add jar spatial-sdk-hive.jar ; add jar spatial-sdk-json.jar; create temporary function ST_AsText as 'com.esri.hadoop.hive.ST_AsText'; create temporary function ST_Intersects as 'com.esri.hadoop.hive.ST_Intersects'; create temporary function ST_Length as 'com.esri.hadoop.hive.ST_Length'; create temporary function ST_LineString as 'com.esri.hadoop.hive.ST_LineString'; create temporary function ST_Point as 'com.esri.hadoop.hive.ST_Point'; create temporary function ST_Polygon as 'com.esri.hadoop.hive.ST_Polygon'; create temporary function ST_SetSRID as 'com.esri.hadoop.hive.ST_SetSRID'; create temporary function st_geomfromtext as 'com.esri.hadoop.hive.ST_GeomFromText'; create temporary function st_geometrytype as 'com.esri.hadoop.hive.ST_GeometryType'; create temporary function st_asjson as 'com.esri.hadoop.hive.ST_AsJson'; create temporary function st_asbinary as 'com.esri.hadoop.hive.ST_AsBinary'; create temporary function st_x as 'com.esri.hadoop.hive.ST_X'; create temporary function st_y as 'com.esri.hadoop.hive.ST_Y'; create temporary function st_srid as 'com.esri.hadoop.hive.ST_SRID';   SELECT ST_Point(longitude, latitude) from mytable LIMIT 1;     I get  the below error:     Caused by: org.apache.hadoop.hive.ql.exec.UDFArgumentException: Unable to instantiate UDF implementation class com.esri.hadoop.hive.ST_Point: java.lang.IllegalAccessException: Class org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge can not access a member of class com.esri.hadoop.hive.ST_Point with modifiers ""     Any ideas on this error?   Thanks.     ... View more
Labels:

Re: Hive ODBC kerberos Centrify : GSSAPI Error a...

by Contributor in Support Questions
‎11-06-2017 05:38 AM
‎11-06-2017 05:38 AM
It was a problem with KDC admin server has only Private IP.   Now I'm able to connect Hive ODBC by using DBeaver.     Thanks. ... View more

Re: Hive ODBC kerberos Centrify : GSSAPI Error a...

by Contributor in Support Questions
‎11-03-2017 10:21 AM
‎11-03-2017 10:21 AM
Thanks, @EricL. It was an FQDN issue.   And I've changed FQDN From _Host to HiveServer2.   Now I get the following error message:   FAILED! [Microsoft][Hardy] (34) Error from server: SSL_connect: unknown protocol.     We are using Centrifydc and windows server on the same Network.    Any ideas on this error?   Thanks again @EricL. ... View more
Contact Me
Online
Offline
Last Visited
‎03-09-2021 02:36 PM
Community Statistics
Member Since ‎09-13-2017 05:25 PM
Last Visited ‎03-09-2021 02:36 PM
Posts 17
Kudos received 2