-1INTO return_val (SELECT count(DISTINCT(stat) FROM my_table AND EXTRACT(MONTH FROM PARTITION_DATE) = EXTRACT(MONTH FROM TO_DATE("20190605", 'YYYY-MM-DD'
我的表和查询的详细信息可以在前面的问题中找到(我现在感兴趣的是如何在HIVE/hiveQL中这样做)。表和查询以供参考:pers_key - unique identifyer for each personvisit_date- date at which they visited a businesscondition - string
start_d
hive -e "create external table temp_db.temp_table (a char(10), b int) PARTITIONED BY (PART_DATE VARCHARFIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION '/work/temp_db/temp_table'"
我在saveAsTextFile()和scalahive -e
使用HIVE SQL,我目前有一个查询,它使用以下语句在每个星期天运行, Select * from tableA
wheredate between date_add(current_date,-7) and date_Add(current_Date, -1) 如果发生了一些事情,并且这段代码必须在星期一运行,我必须手动将日期添加到-8和-2。