Member since
08-16-2017
141
Posts
4
Kudos Received
5
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
281 | 02-17-2022 01:17 AM | |
308 | 11-09-2021 11:03 PM | |
1407 | 11-05-2021 06:34 AM | |
335 | 10-28-2021 01:14 AM | |
1636 | 10-18-2021 06:06 AM |
05-16-2022
11:59 PM
Hi Djentlguy, It is hard to say what is the actual issue we are hitting. We have to look into the Hive/App logs. Could you open a Cloudera support case to report this issue?
... View more
11-09-2021
11:03 PM
Hope the below document can answer your question. https://impala.apache.org/docs/build/html/topics/impala_struct.html It looks like we have to change the query as below: select abc, def, b1.c1 from xxx, xxx.a1 where so n so
... View more
11-05-2021
06:34 AM
@Sam7 please try : select concat(UPPER(SUBSTRING(fieldname,1,2)),LOWER(SUBSTRING(fieldname,3,LENGTH(fieldname)))) AS fieldname from ... You can check the below document for the usage of substring() https://cwiki.apache.org/confluence/display/hive/languagemanual+udf
... View more
10-28-2021
01:14 AM
Hive doesn't provide the rest API itself. The user has to connect Hive by using JDBC/ODBC to fetch the data. Alternatively, you may write the query result to the ADLS and fetch the data via ADLS rest API. https://docs.qubole.com/en/latest/user-guide/engines/presto/insert.html
... View more
10-18-2021
06:06 AM
1 Kudo
With hive query, please try select concat(UPPER(SUBSTRING(fieldname,1,1)),LOWER(SUBSTRING(fieldname,2,LENGTH(fieldname)))) AS fieldname from ...
... View more
05-22-2019
09:42 PM
Hello Fawze, Not sure if you are still experiencing the same issue for now. This issue was resolved from CDH 5.15. As a workaround for the CDH version before 5.15, I would suggest you to add any non existing user in Default pool settings. ## CM->Clusters->Dynamic Resource Pool Configuration->Impala Admission Control-> Default Settings->Check "Allow these users and groups to submit to this pool"-> Add any non existing user under "Users". Like "<non_existing_user>" Refresh Dynamic resource pool. And try to re run the impala query and check if it still throwing the error or not. Thanks Benny
... View more
07-09-2018
06:09 PM
oozie.action.max.output.data is the Max size in characters for output data. The logical max size that you can store is 16MB in the DB. Setting high value to this setting will not affect Oozie job per say, however, it will affect any operations that will interact with DB, both reading and writing. I recommend that you keep this number as small as possible, ideally no more than 2MB.
... View more
10-11-2017
11:25 PM
Please also try to use Cloudera Manager navigate to, Oozie > Configuration > Oozie Server Group > Advance > Oozie Server Advanced Configuration Snippet (Safety Valve) for oozie-site.xml
... View more