Member since
09-24-2015
527
Posts
136
Kudos Received
19
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2130 | 06-30-2017 03:15 PM | |
3053 | 10-14-2016 10:08 AM | |
8317 | 09-07-2016 06:04 AM | |
10063 | 08-26-2016 11:27 AM | |
1449 | 08-23-2016 02:09 PM |
03-01-2016
08:05 PM
3 Kudos
Hi: the last solution was fine, but also work this: orders4 = FOREACH orders3 GENERATE $0 as freq, (chararray) ((word matches '.*..*') ? SUBSTRING(word,INDEXOF(word,'.',0)+1,LAST_INDEX_OF(word,'.')) : $1) as word;
... View more
03-07-2016
10:36 AM
Hi: After install the H2o cluster i run some algoritmict, i can say it very good 🙂 Many thanks.
... View more
02-23-2016
09:46 AM
1 Kudo
Hi: Thanks for the information, finally, i used this: $0#'VARIABLE'#'IMP-NOMINAL-F' Many thanks
... View more
02-22-2018
11:14 AM
Run below command, data will be visible in table msck repair table <table_name>;
... View more
02-17-2016
12:59 PM
@Roberto Sancho here's a list of all deprecated mapred properties and new properties, https://hadoop.apache.org/docs/stable/hadoop-project-dist/hadoop-common/DeprecatedProperties.html the property you're looking for is called mapreduce.job.reduces
... View more
02-18-2016
10:20 AM
Hi: Yes i sued the compress but still log time the reducer tasks, i think its in the merge final tasks, the shuffle and sort i think its fine. Ill try the combiner class from R. Ill inform you. Many thanks
... View more
11-03-2016
11:45 PM
Actually I refer to a complete schema as soon as possible. First when I describe it when loading the hive table, then when I transform data. Works fine for me when I need to clean fields with complex criterias within the same table. A = LOAD 'hive_table' USING org.apache.hive.hcatalog.pig.HCatLoader() as (f0: chararray,f1: chararray,f2: chararray;
B = FOREACH A GENERATE $0 as (f0:chararray),$1 as (f1:chararray),REPLACE($2,'John Doe','Mr Bean') as (f2:chararray);
STORE B INTO 'hive_table' using org.apache.hive.hcatalog.pig.HCatStorer();
... View more
02-15-2016
03:20 PM
Hi: it work with me like this, many thanks 🙂 register /usr/lib/piggybank/hive-hcatalog-pig-adapter.jar
register /usr/lib/piggybank/hive-common.jar;
register /usr/lib/piggybank/hive-metastore.jar;
register /usr/lib/piggybank/hive-exec.jar;
register /usr/lib/piggybank/hive-serde.jar;
register /usr/lib/piggybank/hive-shims.jar;
register /usr/lib/piggybank/libfb303.jar
... View more
02-23-2016
07:46 AM
@Roberto Sancho I would go for SpagoBI see this ratings I have a PhD research paper from Geneva university that confirms this choice too
... View more