<!DOCTYPE html><htmllang='en'><head><title>Documentation | Taos Data</title><metaname='description'content='TDengine is an open-source big data platform for IoT. Along with a 10x faster time-series database, it provides caching, stream computing, message queuing, and other functionalities. It is designed and optimized for Internet of Things, Connected Cars, and Industrial IoT. Read the documentation for TDengine here to get started right away.'><metaname='keywords'content='TDengine, Big Data, Open Source, IoT, Connected Cars, Industrial IoT, time-series database, caching, stream computing, message queuing, IT infrastructure monitoring, application performance monitoring, Internet of Things,TAOS Data, Documentation, programming, coding, syntax, frequently asked questions, questions, faq'><metaname='title'content='Documentation | Taos Data'><metaproperty='og:site_name'content='Taos Data'/><metaproperty='og:title'content='Documentation | Taos Data'/><metaproperty='og:type'content='article'/><metaproperty='og:url'content='https://www.taosdata.com/en/documentation/faq/index.php'/><metaproperty='og:description'content='TDengine is an open-source big data platform for IoT. Along with a 10x faster time-series database, it provides caching, stream computing, message queuing, and other functionalities. It is designed and optimized for Internet of Things, Connected Cars, and Industrial IoT. Read the documentation for TDengine here to get started right away.'/><linkrel='canonical'href='https://www.taosdata.com/en/documentation/faq/index.php'/><script src='../lib/jquery-3.4.1.min.js'type='application/javascript'></script><linkhref='../lib/bootstrap.min.css'rel='stylesheet'><linkhref='../styles/base.min.css'rel='stylesheet'><linkrel='stylesheet'href='../lib/docs/taosdataprettify.css'><linkrel='stylesheet'href='../lib/docs/docs.css'><script src='../lib/docs/prettify.js'></script><script src='../lib/docs/prettyprint-sql.js'></script></head><body><script>$('#documentation-href').addClass('active')</script><divclass='container-fluid'><mainclass='content-wrapper'><sectionclass='documentation'><ahref='../index.html'>Back</a><h1>FAQ</h1>
<p>The client may encounter connection errors. Please follow the steps below for troubleshooting:</p><ol><li>On the server side, execute <code>systemctl status taosd</code> to check the status of <em>taosd</em> service. If <em>taosd</em> is not running, start it and retry connecting.</li><li>Make sure you have used the correct server IP address to connect to.</li><li>Ping the server. If no response is received, check your network connection.</li><li>Check the firewall setting, make sure the TCP/UDP ports from 6030-6039 are enabled.</li><li>For JDBC, ODBC, Python, Go connections on Linux, make sure the native library <em>libtaos.so</em> are located at /usr/local/lib/taos, and /usr/local/lib/taos is in the <em>LD_LIBRARY_PATH</em>. </li><li>For JDBC, ODBC, Python, Go connections on Windows, make sure <em>driver/c/taos.dll</em> is in the system search path (or you can copy taos.dll into <em>C:\Windows\System32</em>)</li><li>If the above steps can not help, try the network diagnostic tool <em>nc</em> to check if TCP/UDP port works check UDP port：<code>nc -vuz {hostIP} {port}</code> check TCP port on server: <code>nc -l {port}</code> check TCP port on client: <code>nc {hostIP} {port}</code></li></ol><h4>2. Why I get "Invalid SQL" error when a query is syntactically correct?</h4><p>If you are sure your query has correct syntax, please check the length of the SQL string, it shall be less than 64KB. </p><h4>3. Why I could not delete a super table?</h4><p>Please make sure there are no tables under the super table. You could not delete a super table which still has associated tables. </p><h4>4. Does TDengine support validation queries?</h4><p>For the time being, TDengine does not have a specific set of validation queries. However, TDengine comes with a system monitoring database named 'sys', which can usually be used as a validation query object. </p><h4>5. Can I delete or update a record that has been written into TDengine?</h4><p>The answer is NO. The design of TDengine is based on the assumption that records are generated by the connected devices, you won't be allowed to change it. But TDengine provides a retention policy, the data records will be removed once their lifetime is passed.</p><h4>6. How do I create a table with more than 250 columns?</h4><p>For a single table, the maximum number of columns is 250. If for some reason, 250 columns are still not quite enough, our suggestion is to split the huge table into several smaller ones.</p><h4>7. What is the most efficient way to write data to TDengine?</h4><p>TDengine supports several different writing regimes. The most efficient way to write data to TDengine is to use batch inserting. For details on batch insertion syntax, please refer to <ahref="../documentation/taos-sql">Taos SQL</a></p><ahref='../index.html'>Back</a></section></main></div><?php include($s.'/footer.php'); ?><script>$('pre').addClass('prettyprint linenums');PR.prettyPrint()</script><script src='lib/docs/liner.js'></script></body></html>
