About mathieu.d

mathieu.d · ‎06-12-2017

>> 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.

mathieu.d · ‎06-09-2017

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';

mathieu.d · ‎05-10-2017

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

mathieu.d · ‎05-04-2017

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.

mathieu.d · ‎05-02-2017

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.

mathieu.d · ‎04-14-2017

Well, one way to do it would be to connect yourself in SSH to the datanodes. For exemple, using putty or winscp.

mathieu.d · ‎04-14-2017

How can you do what ? Which specific part is blocking you ?

mathieu.d · ‎04-14-2017

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.

mathieu.d · ‎04-14-2017

Did you check directly onto the specific data-node that ran the action ? Only that node will have your log "localy"

mathieu.d · ‎04-14-2017

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.

Online	Offline
Last Visited	‎01-17-2018 02:52 AM

Member Since	‎07-16-2015 01:41 AM
Last Visited	‎01-17-2018 02:52 AM
Posts	177
Kudos received	28

Cloudera Community

Re: Unable to delete HDFS Corrupt files

Re: Hive partitions based on date from timestamp

Re: Partition Hive Table to Hbase Handler ?

Re: yarn logs location on disk

Re: Increase Flume graceful restart time

Re: Override Hive Default Path

Re: Override Hive Default Path

Re: Change Email ID | Cloudera community account.

Re: Multiple HPROF files are getting generated wit...

Re: Hive Versions

Re: How to get logs of shell scripts in oozie

Re: How to get logs of shell scripts in oozie

Re: Error in Sqoop Import

Re: How to get logs of shell scripts in oozie

Re: Adding nodes will improve performance ?