taesik

example > $login $db2 create db $db2 connect to $db2 "select * from table(mon_get_tablespace('',-2)) as t" $db2 "select * from table(mon_get_container('',-2)) as t"

tablespace A tablespace is a logical name for a set of one or more containers. A container exists as one of a directory, a file, or a device. When a database is created, three default tablespaces are automatically created. SYSCATSPACE - System catalog table TEMPSPACE1 - temporary space for SQL execution USERSPACE1 - User tables Tablespaces are classified into four types according to their use. R..

var names = ['Alice', 'Bob', 'Tiff', 'Bruce', 'Alice']; var countedNames = names.reduce(function (allNames, name) { if (name in allNames) { allNames[name]++; } else { allNames[name] = 1; } return allNames; }, {}); // countedNames is: // { 'Alice': 2, 'Bob': 1, 'Tiff': 1, 'Bruce': 1 }

Mapping parameters provide various options for how to store the data of the fields to be indexed. analyzer A parameter that stems the data in the field. For text type fields, the analyzer parameter should be used by default. If no separate analyzer is specified, morphological analysis is performed with the Standart Analyzer. normalizer This parameter is used to use the analyzer for the term quer..

mapping_name field_name field_type index_key movieCd keyword movie_name movieNm text produced_Year prdtYear integer release_date release_date integer

Bucket Aggregation Aggregation to aggregate buckets based on fields in the document Metric aggregation Aggregation to calculate SUm, Max, Min, avg from values ​​extracted from documents Matrix aggragation Aggregation that sums or multiplies the values ​​of a matrix. Pipline aggragation Pipeline aggregation reclassify the resulting document derived from the bucket into different field values. Tha..

POST movie/search?size= "aggs":[ "genre": { "terms":{ "field": "genreAlt" }, "aggs":{ "nation":{ "terms": { "field": "nationAlt" } } } } } } { "took": 154, "timed_out": false, "_shards": { "total": 10, "successful": 10, "skipped": 0, "failed": 0 }, "hits":{ "total":63069, "max_score": 0, "hits": [ ] }, "aggregations": { "genre": { "doc_count_error_upper_bound": 136, "sum_other_doc_count": 11220,..

PUT /movie { "settings":{ "number_of_shards":3, "number_of_replicas":2 }, "mappings": "_doc"{ "properties" { "movieCd:{"type":"integer"}, "movieNm":{"type":"text"}, "prdtYear"{"type":"integer"}, "typeNm":{"type":"keyword"}, } } }