由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Programming版 - question about using Hive parameter (转载)
相关主题
问一道HIVE题 关于Efficiencydifference between: char** p and char*p[] ??
big data,菜凉?Any difference between class and typename identifier?
一个没想明白的问题Use Visual .NET for C++ programming
Default function template arguments一个面试题目,用C实现
ajax小问题static如何作为函数?
Windows下大家都用什么SqlConsole啊?address of an array
Querying JSON in Postgres问个c++的问题
template metaprogramming 的问题问一个C++函数Parameter的问题
相关话题的讨论汇总
话题: hiveconf话题: hive话题: foldername话题: parameter
进入Programming版参与讨论
1 (共1页)
s****h
发帖数: 3979
1
【 以下文字转载自 DataSciences 讨论区 】
发信人: squash (南瓜之夭夭), 信区: DataSciences
标 题: question about using Hive parameter
发信站: BBS 未名空间站 (Fri Oct 17 15:20:07 2014, 美东)
question about Hive parameter
Support we have some parameters as:
set nyear = '2014';
set nmonth = '10';
set nday = '17';
We generate a new parameter as:
set newdatestring = concat('/foldername/', ${hiveconf:nyear}, '/', ${
hiveconf:nmonth}, '/', ${hiveconf:nday},'/');
Comparing 2 queries
q1:
select ${hiveconf:newdatestring};
q1 output:
/foldername/2014/10/17/
q2:
select "${hiveconf:newdatestring}";
q2 output:
concat('/foldername/', '2014', '/', '10', '/', '17','/')
The question: is there any setting so that the output of the query 2 is also
'2014/10/17/'?
Why I ask this question?
The real query we want to run is similar to:
create external table tableone( ... ) LOCATION ${hiveconf:newdatestring};
I think the ${hiveconf:newdatestring} in this query is the output of q2
instead of q1.
Thanks for your help.
1 (共1页)
进入Programming版参与讨论
相关主题
问一个C++函数Parameter的问题ajax小问题
C++ 科学计算中的常量Windows下大家都用什么SqlConsole啊?
最新的MS面试题 (转载)Querying JSON in Postgres
one more interview questiontemplate metaprogramming 的问题
问一道HIVE题 关于Efficiencydifference between: char** p and char*p[] ??
big data,菜凉?Any difference between class and typename identifier?
一个没想明白的问题Use Visual .NET for C++ programming
Default function template arguments一个面试题目,用C实现
相关话题的讨论汇总
话题: hiveconf话题: hive话题: foldername话题: parameter