use --hive-drop-import-delims |tr -d '\r' ... View more

This command is not clear.  ... View more

You can use one of those query to reduce num of file in insert query, so it will increase the file size: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy#LanguageManualSortBy-SyntaxofClusterByandDistributeBy ... View more

To append data frames in R, use the rbind() function. The rbind() is a built-in R function that can combine several vectors, matrices, and/or data frames by rows.   When it comes to appending data frames, the rbind() and cbind() function comes to mind because they can concatenate the data frames horizontally and vertically. In this example, we will see how to use the rbind() function to append data frames. ... View more

that worked but when I tried to fire command from admin user (commands like --- hdfs dfs -cp file /user/admin or hdfs dfs -ls /user/) it's not allowing me  giving below error WARN security.UserGroupInformation: PriviledgedActionException as:admin (auth:KERBEROS) cause:javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)] ... View more

@Venkat_ as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. ... View more

  Hi @Broche you can use this script.(for hue) For id column, 2 is default value. You don't have to define default value, its optional. ... View more

When you get below error message when doing kinit using a keytab file klist: Unsupported key table format version number while starting keytab scan Make sure that keytab file is not of zero byte  e.g This is Zero byte keytab file and you will get the above error when trying to do kinit with it -rw------- 1 cloudera-scm cloudera-scm 0 Aug 30 12:15 ./32-cloudera-mgmt-SERVICEMONITOR/cmon.keytab A good keytab file will have non-zero size e.g. 778 for the below file  -rw------- 1 cloudera-scm cloudera-scm 778 Oct 12 05:21 ./150-cloudera-mgmt-SERVICEMONITOR/cmon.keytab   ... View more

This is not working.  Please let me know how to use full path ... View more

Try with the sql statement:    select VALUE from scm.CONFIGS where ATTR="kdc_admin_user";   scm is the CM database in the example. ... View more