Hi Luis, If you run SHOW TABLES in the Impala ODBC session do you see the list of tables? Are only the external tables missing? Can you try running SHOW CURRENT ROLES to see if the lost of Sentry roles matches what you expect. I would also recommend checking the Impala logs, these will shed some more light on whether the table is not visible or if you are being denied access.   Kind regards, Jim ... View more

Hi, In both of these cases it looks like the certificate validation has failed. This typically happens when the Certificate Authority (CA) certificate is missing, has incorrect permissions set or does not have the correct password set. Check that you have added any CA certificates required to your trust store; in this case you need th CA certificate for GlobalSign. You will find details on how to configure TLS for these services in the Cloudera documentation. https://www.cloudera.com/documentation/enterprise/5-16-x/topics/impala_ssl.html https://www.cloudera.com/documentation/enterprise/5/latest/topics/cm_sg_ssl_hue.html Regards, Jim ... View more

Can you test an LDAP query from the Hue server using a client such as ldapsearch? It would be good to see how long it takes to get a response from the LDAP server. Check the value you set for base_dn. If this is overly broad it may take a long time to find users and groups in LDAP. Look to narrow this down as much as possible to reduce the size of the LDAP search. I'd also recommend reading the documentation as this provides information on how you can configure and test LDAP authentication in Hue. https://www.cloudera.com/documentation/enterprise/latest/topics/hue_sec_ldap_auth.html Regards, Jim ... View more

Is that a message you see in the browser or in the logs? Check the log file /var/log/cloudera-scm-server/cloudera-scm-server.log as well, this might give you a better idea what is going on. ... View more

What do the Cloudera Manager logs say about the failed logins? They might give a clue as to why authentication is failing. ... View more

Hi, You can use the command `hadoop checknative` to see which native libraries are being loaded. In the example below I check the native libraries and then change LD_LIBRARY_PATH and run the command again. In the second example you can see I'm loading libz from a different location.   [cloudera@quickstart ~]$ hadoop checknative 18/09/27 14:06:47 INFO bzip2.Bzip2Factory: Successfully loaded & initialized native-bzip2 library system-native 18/09/27 14:06:47 INFO zlib.ZlibFactory: Successfully loaded & initialized native-zlib library Native library checking: hadoop:  true /usr/lib/hadoop/lib/native/libhadoop.so.1.0.0 zlib:    true /lib64/libz.so.1 snappy:  true /usr/lib/hadoop/lib/native/libsnappy.so.1 lz4:     true revision:10301 bzip2:   true /lib64/libbz2.so.1 openssl: true /usr/lib64/libcrypto.so [cloudera@quickstart ~]$ cp /lib64/libz.so.1 lib/ [cloudera@quickstart ~]$ export LD_LIBRARY_PATH=$PWD/lib [cloudera@quickstart ~]$ hadoop checknative 18/09/27 14:07:29 INFO bzip2.Bzip2Factory: Successfully loaded & initialized native-bzip2 library system-native 18/09/27 14:07:29 INFO zlib.ZlibFactory: Successfully loaded & initialized native-zlib library Native library checking: hadoop:  true /usr/lib/hadoop/lib/native/libhadoop.so.1.0.0 zlib:    true /home/cloudera/lib/libz.so.1 snappy:  true /usr/lib/hadoop/lib/native/libsnappy.so.1 lz4:     true revision:10301 bzip2:   true /lib64/libbz2.so.1 openssl: true /usr/lib64/libcrypto.so   Hope this helps, Jim ... View more

Edit the file /etc/hosts. It maps the hostname to the IP address. In most cases the quickstart VM gets this right, if you experience an issue restarting usually fixes it.   Regards, Jim ... View more

It looks like a problem with your SSL/TLS configuration. Check that the trust store contains the correct certificates. When you upgraded the JDK did did you remember to add your certificates to the cacerts truststore? Regards, Jim ... View more

* Do you have the e3base_kfapp in /etc/krb5.conf? * You are using a short hostname for the zookeeper node, not a FQDN. This means it's likely going to use the default kerberos realm. * Is there a domain mapping for the zookeeper address to the correct realm in /etc/krb5.conf ... View more

If you want to be able to run any SQL as hive you would need to create a role, grant privileges to that role and grant the role to hive. Hive is a superuser insofar as it can grant roles, but by default it has no Sentry roles assigned to it. Regards, Jim ... View more

A CREATE TABLE statement will not start a YARN job, so allocating more memory for YARN is unlikely to fix this. What happens when you run the statement? Is there anything in the logs that give a clue what's happening? Regards, Jim ... View more

Do you have the address quickstart.cloudera in /etc/hosts? If this is set incorrectly then trying to access the cluster using the hostname will always attempt to use the old address. Update the address in the hosts file and try again, see if that helps.   Regards, Jim ... View more

Hi, Cloudera Director uses the IP address of the Cloudera Manager server to communicate with it. This means you need the IP address of the server in the TLS certificate for this to work. You can find more information on this in the Cloudera documentation:   https://www.cloudera.com/documentation/ director /latest/topics/director_tls_enable.html#concept_dcl_2dt_kbb   If you can add the private IP address for the Cloudera Manager as a Subject Alternative Name (SAN) in the certificate then this should work around the issue.   Regards, Jim ... View more

Try running "yum clean all" and try running the installer again. This will clear your yum cache and will often fix this kind of issue. Jim ... View more

Try running "yum clean all" and try running the installer again. This will clear your yum cache and will often fix this kind of issue. Jim ... View more

Glad to hear it! ... View more

Hi, it sounds like your BI tools is a 3rd party product. I would recommend you contact the vendor of the BI tool for support. Regards, Jim ... View more

Hi, Amazon Linux is not currently supported and I am not aware of any plans to include it in the supported platforms. You'll find the details of the supported operating systems in the Cloudera documentation link below. https://www.cloudera.com/documentation/enterprise/release-notes/topics/rn_consolidated_pcm.html Regards, Jim ... View more

Hi, What do your Navigator logs say? The log files will tell you why the server crashed. What did you set the heap size to? Regards, Jim ... View more

Hi, Cloudera Navigator provides auditing and data management. Removing it will not stop you from being able to run jobs on your cluster but you will not have fine grained auditing, metadata tagging etc.   Regards, Jim ... View more

Hi, The .hprof files are memory dumps created when a Java process fails due to lack of memory. It could be that either the server itself has insufficient memory or that the Navigator configuration does not allocate enough memory to the JVM. How much RAM does the VM running the master have? Regards, Jim ... View more

Hi, Can you check the log file /var/log/cloudera-scm-server/cloudera-scm-server.log, it should provide more details about the error you are seeing. Regards, Jim ... View more

Hi, The speed of the compression codec is only part of the story, you should also consider the support for the codec in different parts of the Hadoop stack. Gaining slightly faster compression at the expense of compatibility is probably not a good trade off. Snappy is supported by pretty much all of the stack for example, whereas LZ4 is not currently supported by Impala. If in doubt I would stick with Snappy since it is a reasonably fast and splittable codec. If performance is an issue you're likely to find greater benefit focusing on other parts of the stack rather than data compression. Regards, Jim ... View more