sql server - Elastic search does not returns any results -


i trying use elastic search mssql cant find results

the table name orders_table , fields [orderid],[customername],[userfullname],[status]

step 1: build index 

post /_river/mytest_river/_meta {     "type":"jdbc",     "jdbc":      {         "driver":"com.microsoft.sqlserver.jdbc.sqlserverdriver",         "url":"jdbc:sqlserver://[my_ip];databasename=mega",         "user":"sa","password":"******",         "sql":"select [orderid],[customername],[userfullname],[status]  [orders_table]",         "poll":"5s",         "index": "mega",         "type": "orders_table"          } }

the result 

{    "_index": "_river",    "_type": "mytest_river",    "_id": "_meta",    "_version": 2,    "created": false }

step 2: mappings

put /_river/_mappings/orders_table {     "orders_table" : {         "properties" : {             "orderid" : {"type" : "integer"},             "customername" : {"type" : "string" },             "userfullname" : {"type" : "string" },             "status" : {"type" : "string" }         }     } }

the result 

{    "acknowledged": true }

step 3: _search

post /_river/mytest_river/_search {     "query": {          "multi_match": {            "query":    "7694964",             "fields": [ "orderid" ]         }     }  }

the results

{    "took": 4,    "timed_out": false,    "_shards": {       "total": 1,       "successful": 1,       "failed": 0    },    "hits": {       "total": 0,       "max_score": null,       "hits": []    } }

why row [orderid]=7694964 not found?

why hits 0??

how can bring table results instead of hits?

try

post /mega/orders_table/_search {     "query": {          "multi_match": {            "query":    "7694964",             "fields": [ "orderid" ]         }     },     "size": 100 }

to 100 documents or use scan , scroll paginated results or from/size same. but, careful size, don't want set big values in there because can bring cluster down. best be, if have many documents, use scan , scroll.


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more