Member since
10-23-2017
30
Posts
5
Kudos Received
2
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 3645 | 05-31-2019 03:57 PM |
05-31-2019
03:57 PM
the fix is to set this: `set hive.support.sql11.reserved.keywords=true;`
... View more
05-31-2019
02:41 PM
Hi When i do a SELECT null; at cli hive i get a good answer -> NULL when i do this in beeline , i get Error: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:7 Invalid table alias or column reference 'null': (possible column names are: ) (state=42000,code=10004) this is working on one of my clusters but not in one of them (hdp 2.6.1 Connected to: Apache Hive (version 2.1.0.2.6.1.0-129) Driver: Hive JDBC (version 1.2.1000.2.6.1.0-129) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive ) i need this to work, since when i query INSERT OVERWRITE TABLE schema.customer SELECT CUST_ACCOUNTS otherschema.CUST_ACCOUNT_ID, NULL AS ACCOUNT FROM xxxx ; i really appreciate any help
... View more
Labels:
- Labels:
-
Apache Hive
07-17-2018
07:35 PM
hbase-protocol-1.1.2.2.3.2.0-2950.jar
... View more
01-29-2018
09:02 PM
Remember If you have KAFKA : you need to change at config -> kafka brokers -> listeners back to PLAINTEXT://localhost:6667 (from PLAINTEXTSASL://localhost:6667)
... View more
11-22-2017
03:51 PM
When disabling Kerberos at Ambari .some configuration is misconfigures, and restarting Ambari server, you get this error 22 Nov 2017 12:30:53,837 INFO [main] KerberosChecker:64 - Checking Ambari Server Kerberos credentials.
22 Nov 2017 12:30:53,858 ERROR [main] KerberosChecker:120 - xxxxxxx.xxxxxxxx.com.ar: unknown error
22 Nov 2017 12:30:53,860 ERROR [main] AmbariServer:1073 - Failed to run the Ambari Server
org.apache.ambari.server.AmbariException: Ambari Server Kerberos credentials check failed.
Check KDC availability and JAAS configuration in /etc/ambari-server/conf/krb5JAASLogin.conf
at org.apache.ambari.server.controller.utilities.KerberosChecker.checkJaasConfiguration(KerberosChecker.java:121)
at org.apache.ambari.server.controller.AmbariServer.main(AmbariServer.java:1064) the same worker for me vi /etc/ambari-server/conf/ambari.properties set the following authentication.kerberos.enabled=false kerberos.check.jaas.configuration=false
... View more