Member since
05-16-2016
783
Posts
112
Kudos Received
39
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1363 | 06-12-2019 09:27 AM | |
2379 | 05-27-2019 08:29 AM | |
4282 | 05-27-2018 08:49 AM | |
3698 | 05-05-2018 10:47 PM | |
2369 | 05-05-2018 07:32 AM |
08-24-2017
09:36 AM
Using cloudera manager goto Sentry->Configurations Add users/groups to following property to allow them create/show roles. Smaller fonts are property name in the configuration file while regular fonts are display name of the property in the CM. Admin Groups sentry.service.admin.group Allowed Connecting Users sentry.service.allow.connect
... View more
08-24-2017
08:32 AM
I'm not sure there are risks specifically. The best practice is to use Cloudera manager to configure memory limits for different services, so this is the right way to configure things. Cloudera Manager does have support to help set up memory limits for applications: https://www.cloudera.com/documentation/enterprise/latest/topics/cm_mc_autoconfig.html#concept_xjy_vb3_rn . For a production system, it's important to put thought into how much memory your system needs and how it's allocated between different services. E.g. as an earlier poster saw, 256MB is not enough memory to do much interesting with Impala.
... View more
08-21-2017
12:59 PM
Thanks csguna for the reply. I'm not exactly sure how to do that. Do I need to make a modification to the code that is published on exercise 3? https://www.cloudera.com/developers/get-started-with-hadoop-tutorial/exercise-3.html
... View more
08-17-2017
10:41 AM
I figured out the issue. The diffetence comes from /tmp/logs. Weird why hdfs dfs -du -h -s / is not considering /tmp/logs.
... View more
08-15-2017
10:21 PM
Sqoop does not come with the JDBC driver , as you already knew that sqoop is just a client tool it uses the JDBC driver to connect to data source in our case its MYSQL , if you look under the directory /var/lib/sqoop/ should have a MYSQL jdbc driver , internally it will take care of all the connections ,query execution , result sets etc . Since we are using localhost it will connect the locally runining server , if you want to access the remote server then we use 3306 , however you can also mention the port number when refering to localhost , i dont have the vm to see their socket file configuration . moreover you have to enforce the TCP/IP connection because by default when we use localhost it will refer the socket file . Hope this helps .
... View more
08-15-2017
06:55 AM
Thanks Lars. Shannon
... View more
08-14-2017
06:46 PM
Returned 15 row(s) in 0.39s
[localhost.localdomain:21000] > create table emp2 AS
> select name,dept,job from svk.emp;
Query: create table emp2 AS select name,dept,job from svk.emp
ERROR: AnalysisException: Syntax error at:
create table emp2 AS select name,dept,job from svk.emp
^
Encountered: AS
Expected: LIKE
CAUSED BY: Exception: Syntax error
[localhost.localdomain:21000] > create table emp2 LIKE select name,dept,job from svk.emp;
Query: create table emp2 LIKE select name,dept,job from svk.emp
ERROR: AnalysisException: Syntax error at:
create table emp2 LIKE select name,dept,job from svk.emp
^
Encountered: SELECT
Expected: IDENTIFIER
CAUSED BY: Exception: Syntax error
[localhost.localdomain:21000] > create table emp2 LIKE emp;
Query: create table emp2 LIKE emp
[localhost.localdomain:21000] > create table emp2 AS select name,dept,job from svk.emp;
Query: create table emp2 AS select name,dept,job from svk.emp
ERROR: AnalysisException: Syntax error at:
create table emp2 AS select name,dept,job from svk.emp
^
Encountered: AS
Expected: LIKE
CAUSED BY: Exception: Syntax error
[localhost.localdomain:21000] > create table emp3 as select name,dept from emp;
Query: create table emp3 as select name,dept from emp
ERROR: AnalysisException: Syntax error at:
create table emp3 as select name,dept from emp
^
Encountered: AS
Expected: LIKE i have followed as you said, but it is giving below errors
... View more
08-11-2017
08:05 PM
Thanks, i will give it a try, i can create my final tables to have it converted to timestamp. Shannon
... View more
08-11-2017
09:02 AM
Hi, I have dynamic resource pools configured. Do I need to enable Cgroups as well? is it any helpful?
... View more