Allen_Infosys

SQL语句静态变为静态，字符串拼接，concat函数，Hive环境，HiveQL

Referto:https://issues.apache.org/jira/browse/HIVE-7568点击打开链接执行环境：hive cli端执行：hive -f hive.sql报错：FAILED: ParseException line 1:0character 'Reason:Hive.sql这个文件的编码格式为UTF-8格式编码，而被hive认可编译的是

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:hdfs://nameservice1/user/hive/warehouse/test.db/raw/raw.gz is not a directory or unable to create one)

假设表中生日字段为 user_birthday在不计 日时分秒 的情况下：生日                  ==>  年龄user_birthday ==>  floor(((year(current_date)-year(user_birthday))*12+month(current_date)-month(user_birthday))/12)计算

mapreduce执行过程详细讲解,《hadoop权威指南》map,reduce,shuffle,partition, reducer number, splitfile