Member since
09-13-2017
17
Posts
2
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3854 | 03-23-2018 07:34 AM | |
31680 | 11-06-2017 05:38 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
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
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
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
01-17-2018
12:54 PM
Thank you @saranvisa Thank you @Divyani
... View more
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:
- Labels:
-
Cloudera Manager
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:
- Labels:
-
Apache Hive
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
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