Member since
09-24-2015
527
Posts
136
Kudos Received
19
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1767 | 06-30-2017 03:15 PM | |
2461 | 10-14-2016 10:08 AM | |
7746 | 09-07-2016 06:04 AM | |
9362 | 08-26-2016 11:27 AM | |
1166 | 08-23-2016 02:09 PM |
06-12-2016
04:40 PM
3 Kudos
Hi: I fixed it like this: B = FOREACH A GENERATE (chararray) (($3 =='01' AND $4=='11') OR ($3 =='01' AND $4=='13') OR ($3 =='01' AND $4=='21') ? 'CM' : '' )
... View more
06-14-2016
06:43 AM
colud you please type the command example to run a compaction for my table adn bucket in ORC format?? CREATE EXTERNAL TABLE IF NOT EXISTS canal(
CODTF string,
CANAL string,
FECHAOPRCNF string,
FRECUENCIA int,
CODNRBEENF string
)
COMMENT 'A buckered table canal by CODNRBEENF'
CLUSTERED BY (CODNRBEENF)
SORTED BY (FECHAOPRCNF)
INTO 60 BUCKETS
stored as ORC
LOCATION '/RSI/tables/logs/canal'
TBLPROPERTIES ("immutable"="false", "orc.create.index"="true","orc.compress"="ZLIB", "orc.stripe.size"="67108864","orc.row.index.stride"="25000");
... View more
06-11-2016
07:45 AM
Alongside configuring NN disks for RAID, it is recommended to back up the following to safeguard your cluster from failures: HDFS data (Can be done using Falcon)
Hive data (Can be done using Falcon) HBase data (Setup HBase Cluster Replication) Hive metadata (Can be done using Falcon between clusters. Also setup underlying metastore database in HA / active-active mode within the cluster) Regular backup of databases used by Ambari, Oozie, Ranger Configurations Ambari Server and Agent
configurations (Ambari folders under /etc and /var) Configuration files for each
application or service under /etc directory Binaries
(/usr/hadoop/current) Any OS level configuration changes at each node level made in the cluster
... View more
06-08-2016
08:00 AM
Hi: its ok now, its work with this; --query "select ID_INTERNO_PE,MI_FECHA_FIN_MES,COD_NRBE_EN,COD_LINEA,ID_GRP_PD,MI_NUM_TOT_AC_ACT,MI_NUM_AC_SUS,MI_SDO_AC_P,MI_NUM_AC_P,MI_DIA_AC_P,MI_INT_DEV_ACR_D,MI_INT_DEV_DEU_D,MI_COMIS_APL_D,MI_TOT_MOV_D,MI_TOT_MOV_H,MI_TOT_IMP_MOV_D,MI_TOT_IMP_MOV_H from RDWC01.MI_CLTE_ECO_GEN where \$CONDITIONS AND COD_RL_PERS_AC = 01 AND COD_LINEA in ('01','03','04','05') AND COD_NRBE_EN = '3159' AND TRUNC(MI_FECHA_FIN_MES) >=TO_DATE('2010-01-01', 'YYYY-MM-DD')" \
NoteIf you are issuing the query wrapped with double quotes ("), you will have to use \$CONDITIONS instead of just $CONDITIONS to disallow your shell from treating it as a shell variable. For example, a double quoted query may look like: "SELECT * FROM x WHERE a='foo' AND \$CONDITIONS"
Many thanks all of you.
... View more
06-08-2016
06:26 AM
@Roberto Sancho it seems that all your queries has been answered, could you please spare some time and accept a best answer in this thread.
... View more
06-08-2016
06:26 AM
@Roberto Sancho it seems that all your queries has been answered, could you please spare some time and accept a best answer in this thread.
... View more
06-01-2016
09:15 AM
@Roberto Sancho Great.!! :), please accept the answer which helped you to close this thread.
... View more