René's URL Explorer Experiment

Title: How to reduce query execution using hypertable query language · Issue #87 · hypertable/hypertable · GitHub

Open Graph Title: How to reduce query execution using hypertable query language · Issue #87 · hypertable/hypertable

X Title: How to reduce query execution using hypertable query language · Issue #87 · hypertable/hypertable

Description: I have result table. the select query from this table takes upto 40 seconds. do you have any solution? select time,relatedkeywords,rowresults,totalcount,recordsum from result where row='e6f6bff41d43f1047ada758192f495e1' the table structu...

Open Graph Description: I have result table. the select query from this table takes upto 40 seconds. do you have any solution? select time,relatedkeywords,rowresults,totalcount,recordsum from result where row='e6f6bff41d4...

X Description: I have result table. the select query from this table takes upto 40 seconds. do you have any solution? select time,relatedkeywords,rowresults,totalcount,recordsum from result where row='e6f6bff...

Opengraph URL: https://github.com/hypertable/hypertable/issues/87

X: @github

direct link

Domain: github.com

Hey, it has json ld scripts:

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"How to reduce query execution using hypertable query language","articleBody":"I have result table. the select query from this table takes upto 40 seconds. do you have any solution?\r\n`select time,relatedkeywords,rowresults,totalcount,recordsum from result where row='e6f6bff41d43f1047ada758192f495e1'`\r\nthe table structure is as folows\r\n\r\n\u003e hypertable\u003e DESCRIBE TABLE resultdetected;\r\n\u003e \u003cSchema\u003e\r\n\u003e   \u003cAccessGroupDefaults\u003e\r\n\u003e   \u003c/AccessGroupDefaults\u003e\r\n\u003e   \u003cColumnFamilyDefaults\u003e\r\n\u003e   \u003c/ColumnFamilyDefaults\u003e\r\n\u003e   \u003cAccessGroup name=\"default\"\u003e\r\n\u003e     \u003cOptions\u003e\r\n\u003e     \u003c/Options\u003e\r\n\u003e     \u003cColumnFamilyDefaults\u003e\r\n\u003e     \u003c/ColumnFamilyDefaults\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003etotalcount\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003erecordsum\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003erelatedkeywords\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003erowresults\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003etime\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult1\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult2\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult3\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult4\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult5\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult6\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult7\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult8\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult9\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult10\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult11\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult12\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult13\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult14\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult15\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult16\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult17\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult18\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult19\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult20\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult21\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult22\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult23\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult24\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult25\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult26\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult27\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult28\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult29\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult30\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult31\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult32\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult33\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult34\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult35\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult36\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult37\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult38\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult39\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e     \u003cColumnFamily\u003e\r\n\u003e       \u003cName\u003eresult40\u003c/Name\u003e\r\n\u003e       \u003cAccessGroup\u003edefault\u003c/AccessGroup\u003e\r\n\u003e       \u003cDeleted\u003efalse\u003c/Deleted\u003e\r\n\u003e       \u003cOptions\u003e\r\n\u003e       \u003c/Options\u003e\r\n\u003e     \u003c/ColumnFamily\u003e\r\n\u003e   \u003c/AccessGroup\u003e\r\n\u003e \u003c/Schema\u003e\r\n\u003e \r\n\u003e hypertable\u003e \r\n\r\n\r\n","author":{"url":"https://github.com/sunujacob","@type":"Person","name":"sunujacob"},"datePublished":"2018-06-13T14:00:15.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/87/hypertable/issues/87"}

route-pattern	/_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controller	voltron_issues_fragments
route-action	issue_layout
fetch-nonce	v2:290f9f77-b5c1-ccad-f260-7f11e219d2ae
current-catalog-service-hash	81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id	EE00:F97BC:145F041:1BC6609:6A4D7424
html-safe-nonce	4cbaf0fd3bae1b6b0bc24885cb6fcdf103773bd4c766f375a6eca804ed789789
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFRTAwOkY5N0JDOjE0NUYwNDE6MUJDNjYwOTo2QTRENzQyNCIsInZpc2l0b3JfaWQiOiI0NjE4NTY4NzU2ODQyMjk2MzU2IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac	115be44cf401d386dcb384e989aa8310f0b2c6b91fba03dfbaa46e15adb795d1
hovercard-subject-tag	issue:332008366
github-keyboard-shortcuts	repository,issues,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	///voltron/issues_fragments/issue_layout
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/hypertable/hypertable/87/issue_layout
twitter:image	https://opengraph.githubassets.com/7405b974bbc6088fd5860bd07846105529bd97e73524e424c34202a0eaac4d3e/hypertable/hypertable/issues/87
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/7405b974bbc6088fd5860bd07846105529bd97e73524e424c34202a0eaac4d3e/hypertable/hypertable/issues/87
og:image:alt	I have result table. the select query from this table takes upto 40 seconds. do you have any solution? select time,relatedkeywords,rowresults,totalcount,recordsum from result where row='e6f6bff41d4...
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
og:author:username	sunujacob
hostname	github.com
expected-hostname	github.com
None	c78260c7b3f4ac4b0356c8208537f05406a3a2d46a9ec3f735b372dcc519c39e
turbo-cache-control	no-preview
go-import	github.com/hypertable/hypertable git https://github.com/hypertable/hypertable.git
octolytics-dimension-user_id	716226
octolytics-dimension-user_login	hypertable
octolytics-dimension-repository_id	1584552
octolytics-dimension-repository_nwo	hypertable/hypertable
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	true
octolytics-dimension-repository_parent_id	19137
octolytics-dimension-repository_parent_nwo	nuggetwheat/hypertable
octolytics-dimension-repository_network_root_id	19029
octolytics-dimension-repository_network_root_nwo	vicaya/hypertable
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	399fff412f48461d435721c009efc17ea44be72f
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://github.com/hypertable/hypertable/issues/87#start-of-content
	https://github.com/
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fhypertable%2Fhypertable%2Fissues%2F87
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub Copilot appDirect agents from issue to merge	https://github.com/features/ai/github-app
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
View all resources	https://github.com/resources
GitHub SponsorsFund open source developers	https://github.com/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/accelerator
GitHub Stars	https://stars.github.com
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fhypertable%2Fhypertable%2Fissues%2F87
Sign up	https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=hypertable%2Fhypertable
Reload	https://github.com/hypertable/hypertable/issues/87
Reload	https://github.com/hypertable/hypertable/issues/87
Reload	https://github.com/hypertable/hypertable/issues/87
Please reload this page	https://github.com/hypertable/hypertable/issues/87
hypertable	https://github.com/hypertable
hypertable	https://github.com/hypertable/hypertable
nuggetwheat/hypertable	https://github.com/nuggetwheat/hypertable
Notifications	https://github.com/login?return_to=%2Fhypertable%2Fhypertable
Fork 73	https://github.com/login?return_to=%2Fhypertable%2Fhypertable
Star 269	https://github.com/login?return_to=%2Fhypertable%2Fhypertable
Code	https://github.com/hypertable/hypertable
Issues 46	https://github.com/hypertable/hypertable/issues
Pull requests 13	https://github.com/hypertable/hypertable/pulls
Actions	https://github.com/hypertable/hypertable/actions
Projects	https://github.com/hypertable/hypertable/projects
Wiki	https://github.com/hypertable/hypertable/wiki
Security and quality 0	https://github.com/hypertable/hypertable/security
Insights	https://github.com/hypertable/hypertable/pulse
Code	https://github.com/hypertable/hypertable
Issues	https://github.com/hypertable/hypertable/issues
Pull requests	https://github.com/hypertable/hypertable/pulls
Actions	https://github.com/hypertable/hypertable/actions
Projects	https://github.com/hypertable/hypertable/projects
Wiki	https://github.com/hypertable/hypertable/wiki
Security and quality	https://github.com/hypertable/hypertable/security
Insights	https://github.com/hypertable/hypertable/pulse
How to reduce query execution using hypertable query language	https://github.com/hypertable/hypertable/issues/87#top
	https://github.com/sunujacob
sunujacob	https://github.com/sunujacob
on Jun 13, 2018	https://github.com/hypertable/hypertable/issues/87#issue-332008366
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.