select id,fit_product from card_detail  Where fit_product REGEXP '11' AND fit_product REGEXP '12' AND fit_product REGEXP '13' and mem

<if test="useItem != null">
            <if test="useItem.indexOf(',') != -1">
                AND
                <foreach item="item" index="index"
                         collection="useItem.split(',')" open=" " separator="and " close=" ">
                     cd.fit_product REGEXP  #{item}
                </foreach>
            </if>

Select
    a.id,
    a.product,
    a.sale_date,
    a.num ,
    (
        Select
            sum(num)
        FROM
            t_sale_stats b
        Where
            b.id <= a.id
        AND b.product = '产品名称'
        AND b.sale_date >= '2015-03-01'
        AND b.sale_date <= '2015-03-05'
    ) cum_num
FROM
    t_sale_stats a
Where
    a.sale_date >= '2015-03-01'
AND a.sale_date <= '2015-03-05'
AND a.product = '产品名称'
ORDER BY

yarn application -kill  application_1499216480539_24828

#!/bin/bash
hive -e "use hive_dbname;show tables;" > tables.txt
cat tables.txt | while read eachline
do
hive -e "use hive_dbname;show create table $eachline" >>tablesDDL.txt
done

#Set the RDBMS connection params
rbms_driver='com.microsoft.sqlserver.jdbc.SQLServerDriver'
rdbms_connstr="jdbc:sqlserver://MSSQL数据库主机;username=用户名;password=密码;database=库名"
rdbms_username="MSSQL数据库用户名"

@Description(name = "decoder_url", value = "_FUNC_(url [,code][,count]) - decoder a URL from a String for count times using code as encoding scheme ", extended = ""  
    + "if count is not given ,the url will be decoderd for 2 time,"  
    + "if code is not given ,GBK is used")  
public class UDFDecoderUrl extends UDF {  
  private String url = null;  
  private int times = 2;  
  private String code = "GBK";  
  
  public UDFDecoderUrl() {