| <!DOCTYPE html> |
| <!--[if IE]><![endif]--> |
| <html> |
| |
| <head> |
| <!-- Yandex.Metrika counter --> |
| <script type="text/javascript" > |
| (function(m,e,t,r,i,k,a){m[i]=m[i]||function(){(m[i].a=m[i].a||[]).push(arguments)}; |
| m[i].l=1*new Date();k=e.createElement(t),a=e.getElementsByTagName(t)[0],k.async=1,k.src=r,a.parentNode.insertBefore(k,a)}) |
| (window, document, "script", "https://mc.yandex.ru/metrika/tag.js", "ym"); |
| |
| ym(72949126, "init", { |
| clickmap:true, |
| trackLinks:true, |
| accurateTrackBounce:true, |
| webvisor:true |
| }); |
| </script> |
| <noscript><div><img src="https://mc.yandex.ru/watch/72949126" style="position:absolute; left:-9999px;" alt="" /></div></noscript> |
| <!-- /Yandex.Metrika counter --> |
| <script type='text/javascript'> |
| window.__lo_site_id = 284467; |
| |
| (function() { |
| var wa = document.createElement('script'); wa.type = 'text/javascript'; wa.async = true; |
| wa.src = 'https://d10lpsik1i8c69.cloudfront.net/w.js'; |
| var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(wa, s); |
| })(); |
| </script> |
| <link rel="canonical" href="https://ignite.apache.org/releases/latest/dotnetdoc/api/Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.html" /> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> |
| <title>Class SqlFieldsQuery |
| | Apache Ignite.NET </title> |
| <meta name="viewport" content="width=device-width"> |
| <meta name="title" content="Class SqlFieldsQuery |
| | Apache Ignite.NET "> |
| <meta name="generator" content="docfx 2.24.0.0"> |
| |
| <link rel="shortcut icon" href="../images/favicon.ico"> |
| <link rel="stylesheet" href="../styles/docfx.vendor.css"> |
| <link rel="stylesheet" href="../styles/docfx.css"> |
| <link rel="stylesheet" href="../styles/main.css"> |
| <meta property="docfx:navrel" content="../toc.html"> |
| <meta property="docfx:tocrel" content="toc.html"> |
| |
| <meta property="docfx:rel" content="../"> |
| |
| |
| <script async src="https://www.googletagmanager.com/gtag/js?id=UA-61232409-1"></script> |
| <script> |
| window.dataLayer = window.dataLayer || []; |
| function gtag(){dataLayer.push(arguments);} |
| gtag('js', new Date()); |
| |
| gtag('config', 'UA-61232409-1'); |
| </script></head> |
| <body data-spy="scroll" data-target="#affix"> |
| <div id="wrapper"> |
| <header> |
| |
| <nav id="autocollapse" class="navbar navbar-inverse ng-scope" role="navigation"> |
| <div class="container"> |
| <div class="navbar-header"> |
| <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#navbar"> |
| <span class="sr-only">Toggle navigation</span> |
| <span class="icon-bar"></span> |
| <span class="icon-bar"></span> |
| <span class="icon-bar"></span> |
| </button> |
| |
| <a class="navbar-brand" href="../index.html"> |
| <img id="logo" class="svg" src="../images/logo_ignite_32_32.png" alt=""> |
| </a> |
| </div> |
| <div class="collapse navbar-collapse" id="navbar"> |
| <form class="navbar-form navbar-right" role="search" id="search"> |
| <div class="form-group"> |
| <input type="text" class="form-control" id="search-query" placeholder="Search" autocomplete="off"> |
| </div> |
| </form> |
| </div> |
| </div> |
| </nav> |
| |
| <div class="subnav navbar navbar-default"> |
| <div class="container hide-when-search" id="breadcrumb"> |
| <ul class="breadcrumb"> |
| <li></li> |
| </ul> |
| </div> |
| </div> |
| </header> |
| <div class="container body-content"> |
| |
| <div id="search-results"> |
| <div class="search-list"></div> |
| <div class="sr-items"></div> |
| <ul id="pagination"></ul> |
| </div> |
| </div> |
| <div role="main" class="container body-content hide-when-search"> |
| |
| <div class="sidenav hide-when-search"> |
| <a class="btn toc-toggle collapse" data-toggle="collapse" href="#sidetoggle" aria-expanded="false" aria-controls="sidetoggle">Show / Hide Table of Contents</a> |
| <div class="sidetoggle collapse" id="sidetoggle"> |
| <div id="sidetoc"></div> |
| </div> |
| </div> |
| <div class="article row grid-right"> |
| <div class="col-md-10"> |
| <article class="content wrap" id="_content" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery"> |
| |
| |
| <h1 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery" class="text-break">Class SqlFieldsQuery |
| </h1> |
| <div class="markdown level0 summary"><p>SQL fields query.</p> |
| </div> |
| <div class="markdown level0 conceptual"></div> |
| <div class="inheritance"> |
| <h5>Inheritance</h5> |
| <div class="level0"><span class="xref">System.Object</span></div> |
| <div class="level1"><span class="xref">SqlFieldsQuery</span></div> |
| </div> |
| <div class="inheritedMembers"> |
| <h5>Inherited Members</h5> |
| <div> |
| <span class="xref">System.Object.Equals(System.Object)</span> |
| </div> |
| <div> |
| <span class="xref">System.Object.Equals(System.Object, System.Object)</span> |
| </div> |
| <div> |
| <span class="xref">System.Object.ReferenceEquals(System.Object, System.Object)</span> |
| </div> |
| <div> |
| <span class="xref">System.Object.GetHashCode()</span> |
| </div> |
| <div> |
| <span class="xref">System.Object.GetType()</span> |
| </div> |
| <div> |
| <span class="xref">System.Object.MemberwiseClone()</span> |
| </div> |
| </div> |
| <h6><strong>Namespace</strong>: <a class="xref" href="Apache.Ignite.Core.Cache.Query.html">Apache.Ignite.Core.Cache.Query</a></h6> |
| <h6><strong>Assembly</strong>: Apache.Ignite.Core.dll</h6> |
| <h5 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_syntax">Syntax</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public class SqlFieldsQuery : IQueryBaseInternal</code></pre> |
| </div> |
| <h3 id="constructors">Constructors |
| </h3> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery__ctor_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.#ctor*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery__ctor_System_String_System_Boolean_System_Object___" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.#ctor(System.String,System.Boolean,System.Object[])">SqlFieldsQuery(String, Boolean, Object[])</h4> |
| <div class="markdown level1 summary"><p>Constructor,</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public SqlFieldsQuery(string sql, bool loc, params object[] args)</code></pre> |
| </div> |
| <h5 class="parameters">Parameters</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Name</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.String</span></td> |
| <td><span class="parametername">sql</span></td> |
| <td><p>SQL.</p> |
| </td> |
| </tr> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td><span class="parametername">loc</span></td> |
| <td><p>Whether query should be executed locally.</p> |
| </td> |
| </tr> |
| <tr> |
| <td><span class="xref">System.Object</span>[]</td> |
| <td><span class="parametername">args</span></td> |
| <td><p>Arguments.</p> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery__ctor_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.#ctor*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery__ctor_System_String_System_Object___" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.#ctor(System.String,System.Object[])">SqlFieldsQuery(String, Object[])</h4> |
| <div class="markdown level1 summary"><p>Constructor.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public SqlFieldsQuery(string sql, params object[] args)</code></pre> |
| </div> |
| <h5 class="parameters">Parameters</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Name</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.String</span></td> |
| <td><span class="parametername">sql</span></td> |
| <td><p>SQL.</p> |
| </td> |
| </tr> |
| <tr> |
| <td><span class="xref">System.Object</span>[]</td> |
| <td><span class="parametername">args</span></td> |
| <td><p>Arguments.</p> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| <h3 id="fields">Fields |
| </h3> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_DefaultPageSize" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.DefaultPageSize">DefaultPageSize</h4> |
| <div class="markdown level1 summary"><p>Default page size. </p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public const int DefaultPageSize = 1024</code></pre> |
| </div> |
| <h5 class="fieldValue">Field Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Int32</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_DefaultUpdateBatchSize" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.DefaultUpdateBatchSize">DefaultUpdateBatchSize</h4> |
| <div class="markdown level1 summary"><p>Default value for <a class="xref" href="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.html#Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_UpdateBatchSize">UpdateBatchSize</a>. </p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public const int DefaultUpdateBatchSize = 1</code></pre> |
| </div> |
| <h5 class="fieldValue">Field Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Int32</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <h3 id="properties">Properties |
| </h3> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Arguments_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Arguments*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Arguments" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Arguments">Arguments</h4> |
| <div class="markdown level1 summary"><p>Arguments.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public object[] Arguments { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Object</span>[]</td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Colocated_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Colocated*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Colocated" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Colocated">Colocated</h4> |
| <div class="markdown level1 summary"><p>Gets or sets a value indicating whether this query operates on colocated data. |
| <p> |
| Whenever Ignite executes a distributed query, it sends sub-queries to individual cluster members. |
| If you know in advance that the elements of your query selection are colocated together on the same |
| node and you group by colocated key (primary or affinity key), then Ignite can make significant |
| performance and network optimizations by grouping data on remote nodes.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public bool Colocated { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_EnableDistributedJoins_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.EnableDistributedJoins*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_EnableDistributedJoins" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.EnableDistributedJoins">EnableDistributedJoins</h4> |
| <div class="markdown level1 summary"><p>Gets or sets a value indicating whether distributed joins should be enabled for this query. |
| <p> |
| When disabled, join results will only contain colocated data (joins work locally). |
| When enabled, joins work as expected, no matter how the data is distributed.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public bool EnableDistributedJoins { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td><p><code>true</code> if enable distributed joins should be enabled; otherwise, <code>false</code>.</p> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_EnforceJoinOrder_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.EnforceJoinOrder*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_EnforceJoinOrder" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.EnforceJoinOrder">EnforceJoinOrder</h4> |
| <div class="markdown level1 summary"><p>Gets or sets a value indicating whether join order of tables should be enforced. |
| <p> |
| When true, query optimizer will not reorder tables in join. |
| <p> |
| It is not recommended to enable this property until you are sure that your indexes |
| and the query itself are correct and tuned as much as possible but |
| query optimizer still produces wrong join order.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public bool EnforceJoinOrder { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td><p><code>true</code> if join order should be enforced; otherwise, <code>false</code>.</p> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Lazy_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Lazy*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Lazy" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Lazy">Lazy</h4> |
| <div class="markdown level1 summary"><p>Gets or sets a value indicating whether this <a class="xref" href="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.html">SqlFieldsQuery</a> is lazy. |
| <p> |
| By default Ignite attempts to fetch the whole query result set to memory and send it to the client. |
| For small and medium result sets this provides optimal performance and minimize duration of internal |
| database locks, thus increasing concurrency. |
| <p> |
| If result set is too big to fit in available memory this could lead to excessive GC pauses and even |
| OutOfMemoryError. Use this flag as a hint for Ignite to fetch result set lazily, thus minimizing memory |
| consumption at the cost of moderate performance hit.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public bool Lazy { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Local_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Local*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Local" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Local">Local</h4> |
| <div class="markdown level1 summary"><p>Local flag. When set query will be executed only on local node, so only local |
| entries will be returned as query result. |
| <p> |
| Defaults to <code>false</code>.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public bool Local { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_PageSize_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.PageSize*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_PageSize" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.PageSize">PageSize</h4> |
| <div class="markdown level1 summary"><p>Optional page size. |
| <p> |
| Defaults to <a class="xref" href="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.html#Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_DefaultPageSize">DefaultPageSize</a>.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public int PageSize { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Int32</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Partitions_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Partitions*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Partitions" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Partitions">Partitions</h4> |
| <div class="markdown level1 summary"><p>Gets or sets partitions for the query. |
| <p> |
| The query will be executed only on nodes which are primary for specified partitions.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public int[] Partitions { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Int32</span>[]</td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_ReplicatedOnly_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.ReplicatedOnly*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_ReplicatedOnly" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.ReplicatedOnly">ReplicatedOnly</h4> |
| <div class="markdown level1 summary"><p>Gets or sets a value indicating whether this query contains only replicated tables. |
| This is a hint for potentially more effective execution.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">[Obsolete("No longer used as of Apache Ignite 2.8.")] |
| public bool ReplicatedOnly { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Boolean</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Schema_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Schema*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Schema" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Schema">Schema</h4> |
| <div class="markdown level1 summary"><p>Gets or sets the default schema name for the query. |
| <p> |
| If not set, current cache name is used, |
| which means you can omit schema name for tables within the current cache.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public string Schema { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.String</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Sql_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Sql*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Sql" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Sql">Sql</h4> |
| <div class="markdown level1 summary"><p>SQL.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public string Sql { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.String</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Timeout_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Timeout*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_Timeout" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Timeout">Timeout</h4> |
| <div class="markdown level1 summary"><p>Gets or sets the query timeout. Query will be automatically cancelled if the execution timeout is exceeded. |
| Default is <span class="xref">System.TimeSpan.Zero</span>, which means no timeout.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public TimeSpan Timeout { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.TimeSpan</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_UpdateBatchSize_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.UpdateBatchSize*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_UpdateBatchSize" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.UpdateBatchSize">UpdateBatchSize</h4> |
| <div class="markdown level1 summary"><p>Gets or sets batch size for update queries. |
| <p> |
| Default is 1 (<a class="xref" href="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.html#Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_DefaultUpdateBatchSize">DefaultUpdateBatchSize</a>.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public int UpdateBatchSize { get; set; }</code></pre> |
| </div> |
| <h5 class="propertyValue">Property Value</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.Int32</span></td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| <h3 id="methods">Methods |
| </h3> |
| <a id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_ToString_" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.ToString*"></a> |
| <h4 id="Apache_Ignite_Core_Cache_Query_SqlFieldsQuery_ToString" data-uid="Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.ToString">ToString()</h4> |
| <div class="markdown level1 summary"><p>Returns a <span class="xref">System.String</span> that represents this instance.</p> |
| </div> |
| <div class="markdown level1 conceptual"></div> |
| <h5 class="decalaration">Declaration</h5> |
| <div class="codewrapper"> |
| <pre><code class="lang-csharp hljs">public override string ToString()</code></pre> |
| </div> |
| <h5 class="returns">Returns</h5> |
| <table class="table table-bordered table-striped table-condensed"> |
| <thead> |
| <tr> |
| <th>Type</th> |
| <th>Description</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td><span class="xref">System.String</span></td> |
| <td><p>A <span class="xref">System.String</span> that represents this instance.</p> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| <h5 class="overrides">Overrides</h5> |
| <div><span class="xref">System.Object.ToString()</span></div> |
| </article> |
| </div> |
| |
| <div class="hidden-sm col-md-2" role="complementary"> |
| <div class="sideaffix"> |
| <nav class="bs-docs-sidebar hidden-print hidden-xs hidden-sm affix" id="affix"> |
| <!-- <p><a class="back-to-top" href="#top">Back to top</a><p> --> |
| </nav> |
| </div> |
| </div> |
| </div> |
| </div> |
| |
| <footer> |
| <div class="grad-bottom"></div> |
| <div class="footer"> |
| <div class="container"> |
| <span class="pull-right"> |
| <a href="#top">Back to top</a> |
| </span> |
| © 2015 - 2019 The Apache Software Foundation |
| |
| </div> |
| </div> |
| </footer> |
| </div> |
| |
| <script type="text/javascript" src="../styles/docfx.vendor.js"></script> |
| <script type="text/javascript" src="../styles/docfx.js"></script> |
| <script type="text/javascript" src="../styles/main.js"></script> |
| </body> |
| </html> |