{"id":13436,"date":"2019-12-07T09:44:31","date_gmt":"2019-12-07T09:44:31","guid":{"rendered":"http:\/\/bigdata-ir.com\/?p=334"},"modified":"2019-12-07T09:44:31","modified_gmt":"2019-12-07T09:44:31","slug":"%d9%82%d8%a7%d8%a8%d9%84%db%8c%d8%aa-%d9%be%d8%a7%d9%84%d8%a7%db%8c%d8%b4-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7-%db%8c%d8%a7-allow-filtering-%d8%af%d8%b1-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af","status":"publish","type":"post","link":"https:\/\/afaghhosting.net\/blog\/%d9%82%d8%a7%d8%a8%d9%84%db%8c%d8%aa-%d9%be%d8%a7%d9%84%d8%a7%db%8c%d8%b4-%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7-%db%8c%d8%a7-allow-filtering-%d8%af%d8%b1-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af\/","title":{"rendered":"Allow Filtering \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627"},"content":{"rendered":"<p>\u0627\u0645\u0631\u0648\u0632\u0647 \u062a\u0648\u0644\u06cc\u062f \u06a9\u0646\u0646\u062f\u0647 \u0647\u0627\u06cc\u00a0 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u063a\u06cc\u0631\u00a0 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc (nosql) \u062f\u0631 \u062d\u0627\u0644 \u062a\u0644\u0627\u0634 \u0628\u0631\u0627\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u062a\u0648\u0627\u0646\u0645\u0646\u062f\u06cc \u0647\u0627\u06cc \u062e\u0648\u062f \u0647\u0633\u062a\u0646.\u0627\u0632 \u0627\u0646\u062f\u06cc\u0633\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0627\u0646\u062f\u06cc\u0633\u200c\u0647\u0627 \u0628\u0647 \u0633\u0631\u0648\u06cc\u0633\u200c\u062f\u0647\u0646\u062f\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0633\u0637\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u0631\u0627 \u0633\u0631\u06cc\u0639\u200c\u062a\u0631 \u0627\u0632 \u062d\u0627\u0644\u062a \u0628\u062f\u0648\u0646 \u0627\u0646\u062f\u06cc\u0633 \u0628\u06cc\u0627\u0628\u062f.<\/p>\n<p>\u0627\u0645\u0627 \u0646\u06a9\u062a\u0647 \u0627\u06cc\u0646\u062c\u0627\u0633\u062a: \u0627\u0632 \u062f\u0631\u062f\u0633\u0631\u0647\u0627\u06cc \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u062a\u0627\u0632\u0647 \u06a9\u0627\u0631\u060c \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0627\u0633\u062a \u06cc\u0639\u0646\u06cc \u0628\u0631 \u0627\u0633\u0627\u0633 \u06a9\u0648\u0626\u0631\u06cc \u0647\u0627\u06cc \u06a9\u0647 \u0628\u0631\u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u0631 \u0622\u06cc\u0646\u062f\u0647 \u0627\u062c\u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f\u060c \u0645\u06cc\u0628\u0627\u06cc\u0633\u062a \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u0627\u0632 \u0637\u0631\u0641\u06cc \u0646\u062d\u0648\u0647 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0646\u06cc\u0632\u060c \u06a9\u0627\u0645\u0644\u0627 \u0628\u0633\u062a\u0647 \u0628\u0647 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u06cc\u0627 \u06a9\u0644\u06cc\u062f \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0622\u0646 \u062c\u062f\u0648\u0644 \u062f\u0627\u0631\u062f \u0648 \u0631\u0648\u06cc \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u063a\u06cc\u0631 \u06a9\u0644\u06cc\u062f\u060c \u0646\u0645\u06cc \u062a\u0648\u0627\u0646 \u067e\u0631\u0633\u0648\u062c\u0648 \u0648 \u062c\u0633\u062a\u062c\u0648 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.<\/p>\n<p>\u0627\u06cc\u0646 \u0646\u0642\u0637\u0647 \u0636\u0639\u0641 \u0645\u0648\u062c\u0628 \u0645\u06cc\u0634\u0648\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062e\u0627\u0635 \u0628\u0627 \u06a9\u0648\u0626\u0631\u06cc \u0647\u0627\u06cc \u0645\u062a\u0641\u0627\u0648\u062a\u060c\u200c \u06af\u0627\u0647\u06cc \u0645\u062c\u0628\u0648\u0631 \u0645\u06cc \u0634\u0648\u06cc\u0645 \u0686\u0646\u062f\u06cc\u0646 \u062c\u062f\u0648\u0644 \u062f\u0631\u0633\u062a \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06cc\u06a9\u0633\u0627\u0646\u06cc \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f \u0645\u0646\u062a\u0647\u0627 \u0647\u0631 \u06a9\u062f\u0627\u0645 \u062f\u0631 \u06cc\u06a9 \u06a9\u06cc\u0644\u062f \u0627\u0635\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u062f\u0627\u0631\u0646\u062f \u0648 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u06a9\u0648\u0626\u0631\u06cc \u062e\u0627\u0635 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0646\u062f \u0648 \u06cc\u0627 \u0627\u06cc\u0646\u06a9\u0647 \u0627\u0632 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u062b\u0627\u0646\u0648\u06cc\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u0648\u0644\u06cc \u0628\u0627\u06cc\u062f \u0628\u062f\u0627\u0646\u06cc\u0645 \u06a9\u0647 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0647\u0627 \u0645\u0646\u0627\u0628\u0639 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0645\u0627 \u0631\u0627 \u0628\u0647 \u0634\u062f\u062a \u0627\u0634\u063a\u0627\u0644 \u0645\u06cc\u06a9\u0646\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u067e\u0633\u062a \u0647\u0627\u06cc \u06af\u0630\u0634\u062a\u0647 \u062f\u0631 \u0631\u0627\u0628\u0637\u0647 \u0628\u0627 \u062e\u0627\u0635\u06cc\u062a \u0646\u0645\u0627\u0647\u0627\u06cc \u0627\u0632 \u067e\u06cc\u0634 \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u06cc\u0627 Materialized view \u062f\u0631 \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627 \u06a9\u0647 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u062f\u06a9\u0633 \u062b\u0627\u0646\u0648\u06cc\u0647 \u0628\u0648\u062f \u0645\u0637\u0627\u0644\u0628\u06cc \u0627\u0631\u0627\u0626\u0647 \u0634\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u0646\u0648\u0627\u0639 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u06af\u0630\u0627\u0631\u06cc \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0642\u0627\u0628\u0644\u06cc\u062a \u0646\u0645\u0627\u06cc\u0647 \u06af\u0630\u0627\u0631\u06cc SASI \u062c\u0647\u062a \u0641\u0639\u0627\u0644 \u0646\u0645\u0648\u062f\u0646 inverted index \u062f\u0631 \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627 \u0645\u0648\u0631\u062f \u0628\u0631\u0631\u0633\u06cc \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0628\u062d\u062b \u0628\u0647 \u0642\u0627\u0628\u0644\u06cc\u062a \u067e\u0627\u0644\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u06a9\u0633\u0627\u0646\u062f\u0631\u0627 \u0645\u06cc\u067e\u0631\u062f\u0627\u0632\u06cc\u0645. \u0642\u0627\u0628\u0644\u06cc\u062a \u067e\u0627\u0644\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u06a9\u0633\u0627\u0646\u062f\u0631\u0627 3.6 \u0628\u0631\u0627\u06cc \u0628\u0647\u0631\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc \u0628\u0647\u062a\u0631 \u0627\u0632 \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0636\u0627\u0641\u0647 \u0634\u062f. \u0628\u0627 \u0642\u0627\u0628\u0644\u06cc\u062a Allow Filtering \u0627\u0632 \u06a9\u0633\u0627\u0646\u062f\u0631\u0627 3.6 \u0628\u0647 \u0628\u0639\u062f \u0628\u062f\u0648\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u062b\u0627\u0646\u0648\u06cc\u0647 \u0645\u06cc\u062a\u0648\u0627\u0646 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\u060c \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u067e\u0631\u0633\u0648\u062c\u0648\u06cc (where) \u0628\u0631 \u0631\u0648\u06cc \u0647\u0631 \u0641\u06cc\u0644\u062f\u06cc \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f \u0628\u062f\u0648\u0646 \u0622\u0646\u06a9\u0647 \u062f\u0631 \u0634\u0631\u0637 \u06a9\u0644\u06cc\u062f \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u06cc\u0627 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0630\u06a9\u0631 \u0634\u0648\u062f. \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0639\u062f \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u062b\u0627\u0646\u0648\u06cc\u0647 \u0645\u06cc\u062a\u0648\u0627\u0646 \u062f\u0631 \u062c\u062f\u0648\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\u060c \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u067e\u0631\u0633\u0648\u062c\u0648\u06cc (where) \u0628\u0631 \u0631\u0648\u06cc \u0647\u0631 \u0641\u06cc\u0644\u062f\u06cc \u06a9\u0647 \u0627\u06cc\u0646\u062f\u06a9\u0633 \u062b\u0627\u0646\u0648\u06cc\u0647 \u0634\u062f\u0647\u060c \u0628\u062f\u0648\u0646 \u0622\u0646\u06a9\u0647 \u062f\u0631 \u0634\u0631\u0637 \u06a9\u0644\u06cc\u062f \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u06cc\u0627 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0630\u06a9\u0631 \u0634\u0648\u062f\u060c \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f.<\/p>\n<figure id=\"attachment_384\" class=\"wp-caption aligncenter\" aria-describedby=\"caption-attachment-384\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-384\" src=\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2019\/12\/d982d8a7d8a8d984db8cd8aa-d9bed8a7d984d8a7db8cd8b4-d8afd8a7d8afd987-d987d8a7-db8cd8a7-allow-filtering-d8afd8b1-d9bed8a7db8cdaafd8a7d987-d8af.png\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" srcset=\"https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2019\/12\/d982d8a7d8a8d984db8cd8aa-d9bed8a7d984d8a7db8cd8b4-d8afd8a7d8afd987-d987d8a7-db8cd8a7-allow-filtering-d8afd8b1-d9bed8a7db8cdaafd8a7d987-d8af.png 300w, https:\/\/afaghhosting.net\/blog\/wp-content\/uploads\/2019\/12\/d982d8a7d8a8d984db8cd8aa-d9bed8a7d984d8a7db8cd8b4-d8afd8a7d8afd987-d987d8a7-db8cd8a7-allow-filtering-d8afd8b1-d9bed8a7db8cdaafd8a7d987-d8af-1.png 600w\" alt=\"\u0642\u0627\u0628\u0644\u06cc\u062a Allow Filtering \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627\" width=\"553\" height=\"304\" title=\"\"><figcaption id=\"caption-attachment-384\" class=\"wp-caption-text\">\u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627<\/figcaption><\/figure>\n<p><strong>\u0646\u06a9\u062a\u0647<\/strong>: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a Allow Filtering \u0628\u0631 \u0631\u0648\u06cc \u0646\u062a\u0627\u06cc\u062c \u062e\u06cc\u0644\u06cc \u0628\u0632\u0631\u06af \u0645\u0646\u0627\u0633\u0628 \u0646\u06cc\u0633\u062a.<\/p>\n<p><strong>\u0646\u06a9\u062a\u0647<\/strong>: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a Allow Filtering \u0628\u0631 \u0631\u0648\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u0648\u0627\u0633\u0637\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Allow Filtering \u062a\u0639\u062f\u0627\u062f \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u0622\u0646\u0647\u0627 \u062d\u0630\u0641 \u0645\u06cc\u0634\u0648\u062f. \u0647\u0632\u06cc\u0646\u0647 \u0632\u06cc\u0627\u062f\u06cc \u062f\u0627\u0631\u062f \u0648 \u06cc\u06a9 \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u00a0 \u0635\u062d\u06cc\u062d \u0627\u0632\u00a0Allow Filtering \u0646\u06cc\u0633\u062a.<\/p>\n<p><strong>\u0646\u06a9\u062a\u0647<\/strong>: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a Allow Filtering \u062f\u0631 \u0627\u0635\u0644 \u0641\u06cc\u0644\u062a\u0631 \u0632\u062f\u0646 \u0628\u0631 \u0631\u0648\u06cc \u0646\u062a\u06cc\u062c\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc select \u0627\u0633\u062a \u0628\u0647 \u0639\u0628\u0627\u0631\u062a\u06cc \u06af\u0648\u06cc\u0627 \u06cc\u06a9 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u062f\u0648\u0645 \u0628\u0631 \u0631\u0648\u06cc \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0627\u0648\u0644 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u0634\u0648\u062f.<\/p>\n<p><strong>\u0646\u06a9\u062a\u0647<\/strong>: \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0627\u0628\u0644\u06cc\u062a Allow Filtering \u062f\u0631 \u0627\u0635\u0644 \u0641\u06cc\u0644\u062a\u0631 \u0632\u062f\u0646 \u0628\u0631 \u0631\u0648\u06cc \u0646\u062a\u06cc\u062c\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc select \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0633\u0645\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u0646\u062f\u0647 \u0627\u0632 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc\u0634\u0648\u062f \u0628\u0647 \u0639\u06cc\u0627\u0631\u062a\u06cc \u0633\u0631\u0628\u0627\u0631 \u0627\u06cc\u0646 \u0639\u0645\u0644 \u0628\u0631 \u0631\u0648\u06cc \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0645\u0635\u0631\u0641 \u06a9\u0646\u0646\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0627\u0633\u062a. (\u0627\u0644\u0628\u062a\u0647 \u062a\u0627 \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u062a\u0648\u062c\u0647 \u0634\u062f\u0645 \u0628\u0639\u062f\u0627 \u0627\u06af\u0631 \u0648\u0642\u062a \u06a9\u0631\u062f\u0645 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u06a9\u0646\u0645 \u0648 \u0627\u06cc\u0646 \u0646\u06a9\u062a\u0647 \u0631\u0627 \u0627\u0635\u0644\u0627\u062d \u0645\u06cc\u06a9\u0646\u0645)<strong><br \/>\n<\/strong><\/p>\n<p>\u062d\u0627\u0644 \u0628\u0647 \u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0645\u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631\u0633\u062a \u0627\u0632 Allow Filtering \u0631\u0627 \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0628\u06cc\u0627\u0645\u0648\u0632\u06cc\u062f.<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f2f502635988\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\nCREATE TABLE temperature ( &nbsp;weatherstation_id text, &nbsp; event_time timestamp, &nbsp; temperature text, &nbsp; PRIMARY KEY (weatherstation_id,event_time) );<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\">\n<div class=\"crayon-nums-content\">\n<p>1<\/p>\n<p>2<\/p>\n<p>3<\/p>\n<p>4<\/p>\n<p>5<\/p>\n<p>6<\/p>\n<p>7<\/p>\n<p>8<\/p>\n<p>9<\/p>\n<p>10<\/p>\n<p>11<\/p>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-e\">CREATE <\/span><span class=\"crayon-e\">TABLE <\/span><span class=\"crayon-e\">temperature<\/span> <span class=\"crayon-sy\">(<\/span><\/p>\n<p><span class=\"crayon-e\">weatherstation_id <\/span><span class=\"crayon-v\">text<\/span><span class=\"crayon-sy\">,<\/span><\/p>\n<p><span class=\"crayon-e\">event_time <\/span><span class=\"crayon-v\">timestamp<\/span><span class=\"crayon-sy\">,<\/span><\/p>\n<p><span class=\"crayon-e\">temperature <\/span><span class=\"crayon-v\">text<\/span><span class=\"crayon-sy\">,<\/span><\/p>\n<p><span class=\"crayon-e\">PRIMARY <\/span><span class=\"crayon-e\">KEY<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">weatherstation_id<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-v\">event_time<\/span><span class=\"crayon-sy\">)<\/span><\/p>\n<p><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0009 seconds] --><\/p>\n<p dir=\"ltr\">OK Request;<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f3a590114340\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\nSELECT * FROM temperature WHERE weatherstation_id in (&#8216;1234ABCD&#8217;,&#8217;5678EFGH&#8217;);<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-e\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">weatherstation_id <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;1234ABCD&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8216;5678EFGH&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p dir=\"ltr\">OK Request;<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f3d340997931\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\nSELECT * &nbsp; FROM temperature WHERE event_time in (&#8216;2013-04-03 06:00&#8242;,&#8217;2013-04-03 07:00&#8217;);<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-e\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">event_time <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;2013-04-03 06:00&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8216;2013-04-03 07:00&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p dir=\"ltr\">Bad Request: Cannot use IN operator on column not part of the partition key<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f3e510536565\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\nSELECT * &nbsp; FROM temperature WHERE event_time in (&#8216;2013-04-03 06:00&#8242;,&#8217;2013-04-03 07:00&#8217;) ALLOW FILTERING;<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-e\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">event_time <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;2013-04-03 06:00&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8216;2013-04-03 07:00&#8217;<\/span><span class=\"crayon-sy\">)<\/span> <span class=\"crayon-e\">ALLOW <\/span><span class=\"crayon-v\">FILTERING<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p dir=\"ltr\">OK Request;<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f3f810371485\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\nSELECT * FROM temperature WHERE weatherstation_id in (&#8216;1234ABCD&#8217;,&#8217;5678EFGH&#8217;) AND event_time in (&#8216;2013-04-03 06:00&#8242;,&#8217;2013-04-03 07:00&#8217;);<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-e\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">weatherstation_id <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;1234ABCD&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8216;5678EFGH&#8217;<\/span><span class=\"crayon-sy\">)<\/span><\/p>\n<p><span class=\"crayon-st\">AND<\/span> <span class=\"crayon-e\">event_time <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8216;2013-04-03 06:00&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8216;2013-04-03 07:00&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p dir=\"ltr\">OK Request;<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f41455761603\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\ncqlsh:test&gt; SELECT * FROM temperature WHERE temperature in (&#8217;32F&#8217;,&#8217;33F&#8217;);<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-v\">cqlsh<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-v\">test<\/span><span class=\"crayon-o\">&gt;<\/span> <span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-e\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">temperature <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8217;32F&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8217;33F&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0001 seconds] --><\/p>\n<p dir=\"ltr\">Bad Request: Cannot use IN operator on column not part of the partition key<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f42511389552\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\ncqlsh:test&gt; SELECT * FROM temperature WHERE temperature in (&#8217;32F&#8217;,&#8217;33F&#8217;) ALLOW FILTERING;<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-v\">cqlsh<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-v\">test<\/span><span class=\"crayon-o\">&gt;<\/span> <span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-e\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">temperature <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8217;32F&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8217;33F&#8217;<\/span><span class=\"crayon-sy\">)<\/span> <span class=\"crayon-e\">ALLOW <\/span><span class=\"crayon-v\">FILTERING<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0002 seconds] --><\/p>\n<p dir=\"ltr\">OK Request;<\/p>\n<p><!-- Crayon Syntax Highlighter v_2.7.2_beta --><\/p>\n<div id=\"crayon-5deb747e21f43255280612\" class=\"crayon-syntax crayon-theme-classic crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-mouseover\">\n<p><textarea class=\"crayon-plain print-no\" readonly=\"readonly\" wrap=\"soft\" data-settings=\"dblclick\">&lt;br \/&gt;<br \/>\ncqlsh:test&gt; create index on temperature (temperature); cqlsh:test&gt; SELECT * &nbsp;FROM temperature &nbsp;WHERE temperature in (&#8217;32F&#8217;,&#8217;33F&#8217;);<\/textarea><\/p>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"show\"><\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<p><span class=\"crayon-v\">cqlsh<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-v\">test<\/span><span class=\"crayon-o\">&gt;<\/span> <span class=\"crayon-e\">create <\/span><span class=\"crayon-e\">index <\/span><span class=\"crayon-e\">on <\/span><span class=\"crayon-e\">temperature<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-v\">temperature<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<p><span class=\"crayon-v\">cqlsh<\/span><span class=\"crayon-o\">:<\/span><span class=\"crayon-v\">test<\/span><span class=\"crayon-o\">&gt;<\/span> <span class=\"crayon-e \">SELECT *<\/span><\/p>\n<p><span class=\"crayon-e\">FROM <\/span><span class=\"crayon-i\">temperature<\/span><\/p>\n<p><span class=\"crayon-e\">WHERE <\/span><span class=\"crayon-e\">temperature <\/span><span class=\"crayon-st\">in<\/span> <span class=\"crayon-sy\">(<\/span><span class=\"crayon-s\">&#8217;32F&#8217;<\/span><span class=\"crayon-sy\">,<\/span><span class=\"crayon-s\">&#8217;33F&#8217;<\/span><span class=\"crayon-sy\">)<\/span><span class=\"crayon-sy\">;<\/span><\/p>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><!-- [Format Time: 0.0002 seconds] --><\/p>\n<p dir=\"ltr\">OK Request;<\/p>\n<p>\u0622\u062f\u0631\u0633 \u0645\u0646\u0628\u0639:<\/p>\n<p dir=\"ltr\">http:\/\/mechanics.flite.com\/blog\/2014\/01\/08\/the-in-operator-in-cassandra-cql\/<\/p>\n<p>&nbsp;<\/p>\n<p>\u0645\u062f\u06cc\u0631\u06cc\u062a \u0633\u0631\u0648\u0631 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0648 \u0645\u0634\u0627\u0648\u0631\u0647 &#8211; \u062b\u0628\u062a \u062f\u0627\u0645\u0646\u0647<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0627\u0645\u0631\u0648\u0632\u0647 \u062a\u0648\u0644\u06cc\u062f \u06a9\u0646\u0646\u062f\u0647 \u0647\u0627\u06cc\u00a0 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u063a\u06cc\u0631\u00a0 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc (nosql) \u062f\u0631 \u062d\u0627\u0644 \u062a\u0644\u0627\u0634 \u0628\u0631\u0627\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u062a\u0648\u0627\u0646\u0645\u0646\u062f\u06cc \u0647\u0627\u06cc \u062e\u0648\u062f \u0647\u0633\u062a\u0646.\u0627\u0632 \u0627\u0646\u062f\u06cc\u0633\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0627\u0646\u062f\u06cc\u0633\u200c\u0647\u0627 \u0628\u0647 \u0633\u0631\u0648\u06cc\u0633\u200c\u062f\u0647\u0646\u062f\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u062a\u0627 \u0633\u0637\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u0631\u0627 \u0633\u0631\u06cc\u0639\u200c\u062a\u0631 \u0627\u0632 \u062d\u0627\u0644\u062a \u0628\u062f\u0648\u0646 \u0627\u0646\u062f\u06cc\u0633 \u0628\u06cc\u0627\u0628\u062f. \u0627\u0645\u0627 \u0646\u06a9\u062a\u0647 \u0627\u06cc\u0646\u062c\u0627\u0633\u062a: \u0627\u0632 \u062f\u0631\u062f\u0633\u0631\u0647\u0627\u06cc \u06a9\u0627\u0633\u0627\u0646\u062f\u0631\u0627 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[35],"tags":[],"class_list":["post-13436","post","type-post","status-publish","format-standard","hentry","category-bigdata"],"_links":{"self":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/13436","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/comments?post=13436"}],"version-history":[{"count":0,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/posts\/13436\/revisions"}],"wp:attachment":[{"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/media?parent=13436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/categories?post=13436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afaghhosting.net\/blog\/wp-json\/wp\/v2\/tags?post=13436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}