Member since
07-16-2015
177
Posts
28
Kudos Received
19
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
14069 | 11-14-2017 01:11 AM | |
60537 | 11-03-2017 06:53 AM | |
4300 | 11-03-2017 06:18 AM | |
13518 | 09-12-2017 05:51 AM | |
1983 | 09-08-2017 02:50 AM |
06-12-2017
02:14 AM
>> why don't it it creates folder with <dbname>.db folder when you pass the location to create a database(overriding the default path) ? Because that is how hive works when you provide the path. When you specify the path it uses this path. It's not adding a sub folder to the path you have provided. It assumes you have provided the path you want to use exactly.
... View more
06-09-2017
07:47 AM
Why do you expect to see a *.db folder if you don't specify it yourself ? This is not "how it works". The following command sets the root dir of the database "diff" to "/user/cloudera/sat" : Create database diff location '/user/cloudera/sat'; This will not create a folder "diff.db" inside "sat". If this is what you want then use the following command : Create database diff location '/user/cloudera/sat/diff.db';
... View more
05-10-2017
06:43 AM
Hi, I have the exact same question (how can I change my email address tied to this account). Would it be possible for you cjervis to help me ? regards, Mathieu
... View more
05-04-2017
02:04 AM
1 Kudo
The dump refer to the data-node role. Is their a data-node role on the host you call name-node ? If yes, it is the memory of that role you need to increase. I guess the memory allocated to that role is too low. HDFS > configuration > DataNode DefaultGroup > Resource Management > Java Heap Size of DataNode in Bytes in Cloudera Manager. Also, if you don't investigate the content of the dump you can desactivate the generation of the dump in case of OOM in order to not fill up your disk.
... View more
05-02-2017
03:02 AM
2 Kudos
From the documentation of Hive, VARCHAR data type was introduced in Hive 0.12.0. CDH 4.3.0 is an old version of CDH and is based on Hive 0.10.0 I think.
... View more
04-14-2017
04:43 AM
Well, one way to do it would be to connect yourself in SSH to the datanodes. For exemple, using putty or winscp.
... View more
04-14-2017
03:17 AM
How can you do what ? Which specific part is blocking you ?
... View more
04-14-2017
03:12 AM
Well "2017-03-24 00:18:46.0" is basically a string. But I guess the field "modified_date" is a timestamp in your teradata database. Try supplying a timestamp value in the "last-value" parameter.
... View more
04-14-2017
02:46 AM
Did you check directly onto the specific data-node that ran the action ? Only that node will have your log "localy"
... View more
04-14-2017
01:03 AM
That seems rather normal. Low complexity queries tend to use a small amount of yarn containers. Adding containers where you don't have a shortage issue of containers will not speed-up things. But you will be able to handle more concurrent queries without slowing down.
... View more