About Tomas79

Tomas79 · ‎01-02-2019

I think it is indexed in the internal search index of the Hue service. But this is just a guess.. did not checked the source code.

Tomas79 · ‎01-02-2019

I think you are just receiving a warning about the fact that the system swapped out some pages. Cloudera recommends to set the swapping to a minimum level (by setting swappiness to 1 https://www.cloudera.com/documentation/enterprise/latest/topics/cdh_admin_performance.html) Even if you do not run anything, your OS can swap out some pages, so you should probably change this system settings and then the warning will go away,

Tomas79 · ‎12-12-2018

The error indicates your client (kafka-sentry) tries to connect with Kafka service but does not show up any valid ticket from KDC. So try to obtain a valid ticket first with kinit and then try again.

Tomas79 · ‎12-11-2018

It looks like a connection issue to your mysql db, is it? Also, are you sure that the hostname resolution works in your case correctly? You try mysql from command line without specifying the host (so it connects locally) but in your config there is a FQDN defined.

Tomas79 · ‎12-11-2018

Try to check your trash directories as well, it can consume quite a lot of spaces.

Tomas79 · ‎12-11-2018

Lets assume your timestamp column is "t", you just calculate the total minutes for the given day from the timestamp and then filter with OR - either it is more than 20*60 +30 (20:30:00) or is less than 8*60 (08:00:00). select * from mytable where ( date_part('hour', t)* 60 + date_part( 'minute', t) ) >= (20*60+30) or ( date_part('hour', t)* 60 + date_part( 'minute', t) ) < (8*60)

Tomas79 · ‎11-22-2018

You have something definitely wrong in the configuration: Is the host running the mysql database called really "mysql" ? (Because your JDBC connect string looks like this). Can you do the following: Get the MYSQL server hostname Get the MYSQL root username and password And try from every host: mysql -h <MYSQLHOSTNAME> -u <ROOTUSER> -p If you are able to connect, then your database is accesible from every node.

Tomas79 · ‎11-22-2018

I was not able to set Name format, so opted for the second, and it resolved the issue. Thanks @bgooley!

Tomas79 · ‎11-22-2018

Hi, I think installing it via system package manager is a better solution, but in your case I miss a command to change PATH variable. So basically you downloaded, extracted the jdbc driver, but it is not visible. Make it visible system wide by changing your env variables, or put this jdbc driver into a directory where you PATH is pointing to.

Tomas79 · ‎11-21-2018

I am glad, so please accept it as a solution

Online	Offline
Last Visited	‎01-14-2021 05:46 AM

Member Since	‎07-01-2015 06:03 AM
Last Visited	‎01-14-2021 05:46 AM
Posts	460
Kudos received	79

Cloudera Community

Re: Read service-wide configuration values via API

Re: Cloudera Altus - create CM with existing postg...

Re: Spark job getting failed with Jupyter notebook

Re: Create Parameterized view Impala

Re: Unable to access NameNode in cross realm trust...

Re: Document saved in Hue, path in hdfs?

Re: Swap Memory Alerts

Re: kafka with sentry and kerberos CDH 5.13

Re: Cloudera Management Service failed to start

Re: Where did my space on Hadoop cluster go?

Re: Impala - Using Time in where clause and time f...

Re: scm_prepare_database.sh unable to find MySQL J...

Re: HUE fails with saml

Re: scm_prepare_database.sh unable to find MySQL J...

Re: How to insert data into Hive from SparkSQL