Shinsuke Sugaya <******@****.***> 1551046046 +0900

{
  "fess_log.user_info" : {
    "aliases" : { },
    "mappings" : {
      "user_info" : {
        "properties" : {
          "createdAt" : {
            "type" : "date",
            "format" : "date_optional_time"
          },
          "updatedAt" : {
            "type" : "date",
            "format" : "date_optional_time"
          }
        }
      }
    },
    "settings" : {
      "index" : {

Shinsuke Sugaya <******@****.***> 1524115279 +0900

				},
			},
			sql: "LEFT JOIN `user` ON `user_info`.`user_id` = `users`.`id`",
		},
		{
			name: "RIGHT JOIN",
			join: clause.Join{
				Type:  clause.RightJoin,
				Table: clause.Table{Name: "user"},
				ON: clause.Where{
					Exprs: []clause.Expression{clause.Eq{clause.Column{Table: "user_info", Name: "user_id"}, clause.PrimaryColumn}},

                    op.calendarInterval(DateHistogramInterval.HOUR);
                    op.subAggregation(AggregationBuilders.cardinality(USER_INFO_ID).field(USER_INFO_ID));
                    op.minDocCount(0);
                    op.order(BucketOrder.key(true));
                }, null);
            });

        return asEsIndexType();
    }

    @Override
    protected String asEsIndex() {
        return "fess_log.user_info";
    }

    @Override
    public String asEsIndexType() {
        return "user_info";
    }

    @Override
    public String asEsSearchType() {
        return "user_info";
    }

    @Override
    public UserInfoDbm asDBMeta() {
        return UserInfoDbm.getInstance();
    }

    //                                                                          ==========
    protected final String _tableDbName = "user_info";
    protected final String _tableDispName = "user_info";
    protected final String _tablePropertyName = "UserInfo";

    public String getTableDbName() {
        return _tableDbName;
    }

    @Override
    public String getTableDispName() {

    public static final String LOG_TYPE_FAVORITE = "favorite";

    public static final String LOG_TYPE_FAVORITE_COUNT = "favorite_count_agg";

    public static final String LOG_TYPE_USERINFO = "user_info";

    public static final int DEFAULT_PAGE_SIZE = 20;

    public static final int DEFAULT_CURRENT_PAGE_NUMBER = 1;

    private int allRecordCount;

    private int allPageCount;

    @Override
    public UserInfoDbm asDBMeta() {
        return UserInfoDbm.getInstance();
    }

    @Override
    public String asTableDbName() {
        return "user_info";
    }

    @Override
    public boolean hasSpecifiedColumn() {
        return _specification != null;
    }

    @Override
    public ConditionQuery localCQ() {
        return doGetConditionQuery();

    //                                                                       =============
    @Override
    public String asTableDbName() {
        return "user_info";
    }

    @Override
    public String xgetAliasName() {
        return "user_info";
    }

    // ===================================================================================