1. NOT LIKE with array field type
SELECT * FROM localES.article.Article where companies like 'company/google'
Woks ok, but
SELECT * FROM localES.article.Article where companies not like 'company/google'
I got “Failure finding function: like(list, varchar)”
The field company is an array of string.
2. Flatten function
select flatten(field) as something from somewhere where something = 'somevalue'
-> error field something doesn’t exists
3. Equal operator is not working with array field types
select * from localES.article.Article where companies = 'company/google' and companies = 'company/android'
I got no results.
4. Big queries
SELECT *
FROM "localES.article"."Article"
WHERE "companies" LIKE 'company/google' AND "companies" LIKE 'company/android' AND ("companies" = 'company/at-t' OR "companies" = 'company/ibm' OR "companies" = 'company/paypal' OR "companies" = 'company/vscriptlance' OR "companies" = 'company/verizon' OR "companies" = 'company/accenture' OR "companies" = 'company/tata-consultancy-services' OR "companies" = 'company/safeway' OR "companies" = 'company/sony' OR "companies" = 'company/lg' OR "companies" = 'company/boeing' OR "companies" = 'company/digital-equipment-corporation' OR "companies" = 'company/johnson-controls-2' OR "companies" = 'company/wipro' OR "companies" = 'company/build-your-dreams' OR "companies" = 'company/nokia' OR "companies" = 'company/philips-uk' OR "companies" = 'company/cap-gemini' OR "companies" = 'company/infosys-technologies' OR "companies" = 'company/tyco-international' OR "companies" = 'company/foxconn-international-holdings' OR "companies" = 'company/mitsubishi-electric' OR "companies" = 'company/bertelsmann' OR "companies" = 'company/ashoka-group' OR "companies" = 'company/comcast' OR "companies" = 'company/jabil' OR "companies" = 'company/ramshyam' OR "companies" = 'company/savvisdirect' OR "companies" = 'company/localedge' OR "companies" = 'company/metacarta' OR "companies" = 'company/federal-express' OR "companies" = 'company/general-dynamics' OR "companies" = 'company/costco' OR "companies" = 'company/csc' OR "companies" = 'company/microsoft' OR "companies" = 'company/intel' OR "companies" = 'company/oracle' OR "companies" = 'company/cox-enterprises' OR "companies" = 'company/dell' OR "companies" = 'company/ericsson' OR "companies" = 'company/3m' OR "companies" = 'company/marks-spencer' OR "companies" = 'company/alcatel-lucent' OR "companies" = 'company/convergys' OR "companies" = 'company/affiliated-computer-services' OR "companies" = 'company/cgi-group' OR "companies" = 'company/allstate' OR "companies" = 'company/enterprise-holdings' OR "companies" = 'company/americanexpress' OR "companies" = 'company/autozone' OR "companies" = 'company/cisco' OR "companies" = 'company/deltapowersolutions' OR "companies" = 'company/be-motivated-today' OR "companies" = 'company/xerox' OR "companies" = 'company/akzonobel' OR "companies" = 'company/hcl-technologies' OR "companies" = 'company/barnes-noble' OR "companies" = 'company/motorola-solutions' OR "companies" = 'company/merck-co-inc' OR "companies" = 'company/thomson-reuters' OR "companies" = 'company/atos-origin' OR "companies" = 'company/nordstrom' OR "companies" = 'company/saic' OR "companies" = 'company/telstra' OR "companies" = 'company/logica' OR "companies" = 'company/acciona' OR "companies" = 'company/agrokor' OR "companies" = 'company/bristol-myers-squibb' OR "companies" = 'company/nike' OR "companies" = 'company/freeport-mcmoran-copper-gold' OR "companies" = 'company/dish-network' OR "companies" = 'company/sun-microsystems' OR "companies" = 'company/eb-games' OR "companies" = 'company/fruit-of-the-loom' OR "companies" = 'company/nortel-networks' OR "companies" = 'company/texas-instruments' OR "companies" = 'company/avery-dennison' OR "companies" = 'company/rogers-communications-inc' OR "companies" = 'company/google' OR "companies" = 'company/labcorp' OR "companies" = 'company/telus' OR "companies" = 'company/dean-foods' OR "companies" = 'company/kalimatapla' OR "companies" = 'company/bbc' OR "companies" = 'company/reliance-industries' OR "companies" = 'company/the-walt-disney-company' OR "companies" = 'company/network18' OR "companies" = 'company/hertz-global-holdings' OR "companies" = 'company/australia-post' OR "companies" = 'company/svyaznoy' OR "companies" = 'company/swarovski-crystal' OR "companies" = 'company/booz-allen-hamilton' OR "companies" = 'company/chiquita-brands-international' OR "companies" = 'company/kerry-group' OR "companies" = 'company/vanguard-health-systems' OR "companies" = 'company/freescale' OR "companies" = 'company/daily-mail-and-general-trust' OR "companies" = 'company/ntt-docomo' OR "companies" = 'company/ncr' OR "companies" = 'company/baylor-health-care-system' OR "companies" = 'company/on-semiconductor' OR "companies" = 'company/agilent' OR "companies" = 'company/minacs' OR "companies" = 'company/eastman-kodak' OR "companies" = 'company/hyundai-engineering' OR "companies" = 'company/scottish-southern-energy' OR "companies" = 'company/steria' OR "companies" = 'company/hilti' OR "companies" = 'company/knight-ridder' OR "companies" = 'company/pccw' OR "companies" = 'company/avaya' OR "companies" = 'company/limited-brands' OR "companies" = 'company/amd' OR "companies" = 'company/mahindra-mahindra' OR "companies" = 'company/diebold' OR "companies" = 'company/mckinsey-company' OR "companies" = 'company/psychiatric-solutions' OR "companies" = 'company/terex' OR "companies" = 'company/young-rubicam' OR "companies" = 'company/hinduja-global-solutions' OR "companies" = 'company/experian' OR "companies" = 'company/online-business-software' OR "companies" = 'company/commscope-enterprise-solutions' OR "companies" = 'company/ebay' OR "companies" = 'company/gemalto' OR "companies" = 'company/igate-patni' OR "companies" = 'company/libertarian-national-committee' OR "companies" = 'company/iq-backoffice' OR "companies" = 'company/yahoo' OR "companies" = 'company/vmware' OR "companies" = 'company/nampak' OR "companies" = 'company/ca-2' OR "companies" = 'company/360buy-com' OR "companies" = 'company/bloomberg' OR "companies" = 'company/cushman-wakefield' OR "companies" = 'company/parexel' OR "companies" = 'company/arthur-j-gallagher-co' OR "companies" = 'company/avnet' OR "companies" = 'company/lexmark' OR "companies" = 'company/elbit-systems' OR "companies" = 'company/gorenje' OR "companies" = 'company/euro-rscg-worldwide' OR "companies" = 'company/mrx-technologies' OR "companies" = 'company/ppd' OR "companies" = 'company/uoften-com' OR "companies" = 'company/amadeus' OR "companies" = 'company/amrica-mvil' OR "companies" = 'company/eeneltec-group' OR "companies" = 'company/gfk-aktiengesellshaft' OR "companies" = 'company/groupon' OR "companies" = 'company/huawei' OR "companies" = 'company/lennox-international' OR "companies" = 'company/lifestyles-home-decor' OR "companies" = 'company/los-angeles-times-media-group' OR "companies" = 'company/northshore-university-healthsystem' OR "companies" = 'company/pico-rg' OR "companies" = 'company/rakuten' OR "companies" = 'company/sapient' OR "companies" = 'company/siemens-automation' OR "companies" = 'company/sk-stanbul-su-ve-kanalizasyon-daresi' OR "companies" = 'company/thetech360' OR "companies" = 'company/solutia' OR "companies" = 'company/summagroup' OR "companies" = 'company/vivilia' OR "companies" = 'company/globalcaradvice' OR "companies" = 'company/transcontinental' OR "companies" = 'company/dassault' OR "companies" = 'company/life-technologies' OR "companies" = 'company/louis-vuitton' OR "companies" = 'company/sony-mobile' OR "companies" = 'company/polaris-software-lab' OR "companies" = 'company/24-7-customer' OR "companies" = 'company/tech-data' OR "companies" = 'company/givaudan' OR "companies" = 'company/webkinz' OR "companies" = 'company/itron' OR "companies" = 'company/total-system-services' OR "companies" = 'company/epam-systems' OR "companies" = 'company/aol' OR "companies" = 'company/intuit' OR "companies" = 'company/liberty-league-international' OR "companies" = 'company/logitech' OR "companies" = 'company/netapp' OR "companies" = 'company/onehourtranslation' OR "companies" = 'company/renal-care-group' OR "companies" = 'company/sigma-aldrich' OR "companies" = 'company/electronicarts' OR "companies" = 'company/guitar-center' OR "companies" = 'company/autodesk' OR "companies" = 'company/general-instrument' OR "companies" = 'company/mcclatchy' OR "companies" = 'company/american-power-conversion' OR "companies" = 'company/broadcom' OR "companies" = 'company/starcom-mediavest-group' OR "companies" = 'company/wegolook' OR "companies" = 'company/lender-processing-services' OR "companies" = 'company/adobe-systems' OR "companies" = 'company/mantech' OR "companies" = 'company/numonyx' OR "companies" = 'company/moodys' OR "companies" = 'company/persistent-systems' OR "companies" = 'company/identityprotection-com' OR "companies" = 'company/sra-international' OR "companies" = 'company/acxiom' OR "companies" = 'company/business-objects-sa' OR "companies" = 'company/telvent-git' OR "companies" = 'company/reliance-group-holdings' OR "companies" = 'company/atmel' OR "companies" = 'company/baidu' OR "companies" = 'company/chronos-consulting' OR "companies" = 'company/dentsu' OR "companies" = 'company/just-dial' OR "companies" = 'company/prime-view-international' OR "companies" = 'company/symphony-teleca-corporation' OR "companies" = 'company/tata-communications' OR "companies" = 'company/recruit' OR "companies" = 'company/synopsys' OR "companies" = 'company/trk-ekonomi-bankas' OR "companies" = 'company/konami' OR "companies" = 'company/mindray-medical-international' OR "companies" = 'company/mediaset' OR "companies" = 'company/waklimi-financial-group' OR "companies" = 'company/ihs-isuppli' OR "companies" = 'company/iyogi' OR "companies" = 'company/microchip-technologies' OR "companies" = 'company/cpm-braxis' OR "companies" = 'company/lsi' OR "companies" = 'company/del-monte-foods' OR "companies" = 'company/centric-world-of-innovation' OR "companies" = 'company/newscorporation' OR "companies" = 'company/safa-industrial-group' OR "companies" = 'company/hexaware-technologies' OR "companies" = 'company/john-wiley-sons' OR "companies" = 'company/prodiance' OR "companies" = 'company/national-instruments' OR "companies" = 'company/55tuan-com' OR "companies" = 'company/air-astana-airlines' OR "companies" = 'company/amcheck' OR "companies" = 'company/convergia' OR "companies" = 'company/css' OR "companies" = 'company/diamond2deal-2' OR "companies" = 'company/esko' OR "companies" = 'company/flipkart' OR "companies" = 'company/gizmosupport' OR "companies" = 'company/idex-corp' OR "companies" = 'company/kroll-ontrack-data-recovery' OR "companies" = 'company/love-culture' OR "companies" = 'company/lycatalk' OR "companies" = 'company/mcafee' OR "companies" = 'company/party-city' OR "companies" = 'company/shearman-sterling-llp' OR "companies" = 'company/vcare-call-center' OR "companies" = 'company/duoservers' OR "companies" = 'company/empire-east-land-holdings' OR "companies" = 'company/jds-uniphase-corporation' OR "companies" = 'company/mobile-mini-2' OR "companies" = 'company/tyreslocator' OR "companies" = 'company/united-internet' OR "companies" = 'company/mdc-partners' OR "companies" = 'company/hsn' OR "companies" = 'company/cirlce-international-inc' OR "companies" = 'company/kla-tencor' OR "companies" = 'company/gottschalks' OR "companies" = 'company/nrg-energy' OR "companies" = 'company/citrix-systems' OR "companies" = 'company/viewvs' OR "companies" = 'company/alpine-access' OR "companies" = 'company/open-innovations-forum' OR "companies" = 'company/synechron' OR "companies" = 'company/parametric-technology' OR "companies" = 'company/booking-com' OR "companies" = 'company/expedia' OR "companies" = 'company/live-nation-entertainment' OR "companies" = 'company/nykredit-realkredit' OR "companies" = 'company/trend-micro-2' OR "companies" = 'company/factset-research-systems' OR "companies" = 'company/novell' OR "companies" = 'company/otto-2' OR "companies" = 'company/rf-micro-devices' OR "companies" = 'company/clas-ohlson' OR "companies" = 'company/compuware' OR "companies" = 'company/cydcor' OR "companies" = 'company/gameloft' OR "companies" = 'company/gartner' OR "companies" = 'company/mentor-graphics' OR "companies" = 'company/royal-training-institute' OR "companies" = 'company/symphony-services' OR "companies" = 'company/yandex' OR "companies" = 'company/zylog-systems-limited' OR "companies" = 'company/informatica' OR "companies" = 'company/sohu' OR "companies" = 'company/ameripath' OR "companies" = 'company/ihs' OR "companies" = 'company/polycom-2' OR "companies" = 'company/teradyne' OR "companies" = 'company/linkedin' OR "companies" = 'company/wuxi-pharmatech-cayman' OR "companies" = 'company/associated-press' OR "companies" = 'company/drs-defense-solutions' OR "companies" = 'company/ergogroup' OR "companies" = 'company/mslgroup' OR "companies" = 'company/research-triangle' OR "companies" = 'company/verisign' OR "companies" = 'company/metropcs-communications' OR "companies" = 'company/nds' OR "companies" = 'company/aci-worldwide' OR "companies" = 'company/activenetwork' OR "companies" = 'company/conrad-com' OR "companies" = 'company/epsilon' OR "companies" = 'company/gmx-com' OR "companies" = 'company/indiamart' OR "companies" = 'company/salesforce' OR "companies" = 'company/xiaomi' OR "companies" = 'company/coda' OR "companies" = 'company/niit' OR "companies" = 'company/bisnode' OR "companies" = 'company/leucadia-national' OR "companies" = 'company/cable-one' OR "companies" = 'company/godaddy' OR "companies" = 'company/kronos-incorporated-2' OR "companies" = 'company/kudelski-group' OR "companies" = 'company/ziprealty' OR "companies" = 'company/majescomastek' OR "companies" = 'company/zebra-technologies' OR "companies" = 'company/zyxel' OR "companies" = 'company/meredith' OR "companies" = 'company/advantest' OR "companies" = 'company/osi-systems' OR "companies" = 'company/infogroup' OR "companies" = 'company/groundlink' OR "companies" = 'company/amica-mutual-insurance-co' OR "companies" = 'company/check-point' OR "companies" = 'company/comarch' OR "companies" = 'company/comtec-global' OR "companies" = 'company/eci-telecom' OR "companies" = 'company/englishtown' OR "companies" = 'company/inkfruit-2' OR "companies" = 'company/kingdee' OR "companies" = 'company/mail-ru' OR "companies" = 'company/mathworks' OR "companies" = 'company/national-business-research-institute' OR "companies" = 'company/outsurance' OR "companies" = 'company/safexpress-private-limited' OR "companies" = 'company/samtec' OR "companies" = 'company/sixt-rental-cars' OR "companies" = 'company/verio' OR "companies" = 'company/yp-2' OR "companies" = 'company/tibco-software-inc' OR "companies" = 'company/esri' OR "companies" = 'company/camelot-information-systems' OR "companies" = 'company/blackburn-design' OR "companies" = 'company/global-sources' OR "companies" = 'company/globant' OR "companies" = 'company/rackspace-cloud' OR "companies" = 'company/kratos-networks' OR "companies" = 'company/kratos-defense-and-security-solutions' OR "companies" = 'company/altera' OR "companies" = 'company/bwin-party' OR "companies" = 'company/vistaprint' OR "companies" = 'company/vtt' OR "companies" = 'company/genisys-software-ltd' OR "companies" = 'company/tds-telecom' OR "companies" = 'company/microstrategy' OR "companies" = 'company/lotech' OR "companies" = 'company/a-t-kearney' OR "companies" = 'company/brenco' OR "companies" = 'company/canyonranch' OR "companies" = 'company/esignal' OR "companies" = 'company/global-radio' OR "companies" = 'company/iba-group' OR "companies" = 'company/inovisi-infracom' OR "companies" = 'company/perfect-world' OR "companies" = 'company/riya-travel-tours' OR "companies" = 'company/sogeti-usa' OR "companies" = 'company/sri-international' OR "companies" = 'company/sungard-availability-services-uk' OR "companies" = 'company/telefonica-digital' OR "companies" = 'company/walt-disney-internet-group' OR "companies" = 'company/yardi-systems' OR "companies" = 'company/ari-fleet' OR "companies" = 'company/sepracor' OR "companies" = 'company/ceradyne' OR "companies" = 'company/rcm-technologies' OR "companies" = 'company/morningstar' OR "companies" = 'company/housecall-medical-resources' OR "companies" = 'company/unx' OR "companies" = 'company/econocom' OR "companies" = 'company/digi-key-corp' OR "companies" = 'company/tri-city-medical-center' OR "companies" = 'company/valeant-pharmaceuticals-international' OR "companies" = 'company/cme-group' OR "companies" = 'company/safe-local-sex' OR "companies" = 'company/triquint-semiconductor' OR "companies" = 'company/blackbaud' OR "companies" = 'company/kulicke-and-soffa' OR "companies" = 'company/mdl-technology' OR "companies" = 'company/photon-infotech-p-ltd' OR "companies" = 'company/vantiv' OR "companies" = 'company/dena' OR "companies" = 'company/slk-software-services-pvt-ltd' OR "companies" = 'company/mitel-networks-corporation' OR "companies" = 'company/the-chapar' OR "companies" = 'company/leavingstone' OR "companies" = 'company/my-tekies' OR "companies" = 'company/acn-inc' OR "companies" = 'company/applabs' OR "companies" = 'company/arm' OR "companies" = 'company/aspect-software-2' OR "companies" = 'company/aztecsoft' OR "companies" = 'company/bentley-systems' OR "companies" = 'company/camerich' OR "companies" = 'company/cegid' OR "companies" = 'company/classical-martial-arts-centre-hasu-dojo' OR "companies" = 'company/cnetnetworks' OR "companies" = 'company/darkpulse-technologies' OR "companies" = 'company/digi-telecommunications' OR "companies" = 'company/dukanee-com' OR "companies" = 'company/e-verifile-com-inc' OR "companies" = 'company/exportersindia' OR "companies" = 'company/gmo-internet' OR "companies" = 'company/kollmorgen' OR "companies" = 'company/microlab-electronics-co-ltd' OR "companies" = 'company/mumbai-flora' OR "companies" = 'company/netflix' OR "companies" = 'company/one-main-com' OR "companies" = 'company/tradetuber-universal-tech-co-ltd' OR "companies" = 'company/razorfish' OR "companies" = 'company/strategic-outsourcing-services' OR "companies" = 'company/synverse' OR "companies" = 'company/valuelabs' OR "companies" = 'company/vinamost' OR "companies" = 'company/visa-europe' OR "companies" = 'company/wedubox-legency' OR "companies" = 'company/wjt-global-solutions' OR "companies" = 'company/emerson-network-power' OR "companies" = 'company/ideal-cleaning' OR "companies" = 'company/pc-connection' OR "companies" = 'company/shlomo-sixt' OR "companies" = 'company/vse-corp' OR "companies" = 'company/amylin-pharmaceuticals' OR "companies" = 'company/equinix' OR "companies" = 'company/flir-systems' OR "companies" = 'company/insperity' OR "companies" = 'company/solera-holdings' OR "companies" = 'company/techno-forum-software-solutions' OR "companies" = 'company/arris-group' OR "companies" = 'company/affina' OR "companies" = 'company/exact' OR "companies" = 'company/frost-sullivan' OR "companies" = 'company/marlabs-inc' OR "companies" = 'company/mitchell-international' OR "companies" = 'company/riya-travel-tour' OR "companies" = 'company/season-engineering-group' OR "companies" = 'company/intermec' OR "companies" = 'company/e2v-technologies' OR "companies" = 'company/carborundum-universal-limited-3' OR "companies" = 'company/communisis' OR "companies" = 'company/activant-solutions' OR "companies" = 'company/ciklum' OR "companies" = 'company/entegris' OR "companies" = 'company/reachlocal' OR "companies" = 'company/cambridge-assessment' OR "companies" = 'company/f5-networks' OR "companies" = 'company/imec' OR "companies" = 'company/ses' OR "companies" = 'company/immunex' OR "companies" = 'company/acision' OR "companies" = 'company/appostrophic' OR "companies" = 'company/dafiti' OR "companies" = 'company/daum-communications' OR "companies" = 'company/diasoft' OR "companies" = 'company/fortinet' OR "companies" = 'company/giant-interactive' OR "companies" = 'company/netsuite' OR "companies" = 'company/onward-technologies' OR "companies" = 'company/zoho' OR "companies" = 'company/us-apps-development' OR "companies" = 'company/achieve-beyond' OR "companies" = 'company/aquarius-empire' OR "companies" = 'company/batteriescenter-in-au' OR "companies" = 'company/beijing-rayootech-co-ltd' OR "companies" = 'company/ci-t' OR "companies" = 'company/cure-international' OR "companies" = 'company/cytyc' OR "companies" = 'company/drexel-university' OR "companies" = 'company/eclinicalworks' OR "companies" = 'company/global-reponse' OR "companies" = 'company/invensis' OR "companies" = 'company/mediaringtalk' OR "companies" = 'company/mercadolibre' OR "companies" = 'company/neustar' OR "companies" = 'company/newark-element14' OR "companies" = 'company/on-the-dot' OR "companies" = 'company/ozon-ru' OR "companies" = 'company/pch-international' OR "companies" = 'company/prognoz' OR "companies" = 'company/qad' OR "companies" = 'company/retirement-concepts' OR "companies" = 'company/taking-you-forward' OR "companies" = 'company/technologyuserlists') AND CONTAINS(web) AND "pdate" >= TIMESTAMP '2007-10-19 13:11:13' AND "pdate" <= TIMESTAMP '2017-10-19 13:11:13' AND "source" <> 'Wall Street Journal'
I got an error: “StackOverflowError”, and no other details.