afcotroneo
afcotroneo
/ omni-num
Created
October 14, 2021 12:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| port = 6274 | |
| http-port = 6278 | |
| data = "/var/lib/omnisci/data" | |
| null-div-by-zero = true | |
| num-executors = 3 | |
| [web] | |
| port = 6273 | |
| frontend = "/opt/omnisci/frontend" | |
| servers-json = "/var/lib/omnisci/servers.json" |
afcotroneo
/ omni-show-query.sql
Created
October 14, 2021 02:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| show queries; | |
| query_session_id|current_status |executor_id|submitted |query_str |login_name|client_address |db_name|exec_device_type | |
| 713-t1ax |PENDING_QUEUE |0 |2021-08-03 ...|SELECT ... |John |http:::1 |omnisci|GPU | |
| 491-xpfb |PENDING_QUEUE |0 |2021-08-03 ...|SELECT ... |Patrick |http:::1 |omnisci|GPU | |
| 451-gp2c |PENDING_QUEUE |0 |2021-08-03 ...|SELECT ... |John |http:::1 |omnisci|GPU | |
| 190-5pax |PENDING_EXECUTOR |1 |2021-08-03 ...|SELECT ... |Cavin |http:::1 |omnisci|GPU | |
| 720-nQtV |RUNNING_QUERY_KERNEL|2 |2021-08-03 ...|SELECT ... |Cavin |tcp:::ffff:127.0.0.1:50142|omnisci|GPU | |
| 946-ooNP |RUNNING_IMPORTER |0 |2021-08-03 ...|IMPORT_GEO_TABLE|Rio |tcp:::ffff:127.0.0.1:47314|omnisci|CPU |
afcotroneo
/ omni-alter-sys-clear.sql
Created
October 14, 2021 02:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ALTER SYSTEM CLEAR CPU MEMORY | |
| ALTER SYSTEM CLEAR GPU MEMORY | |
| ALTER SYSTEM CLEAR RENDER MEMORY |
afcotroneo
/ omni-scp-select-start.sql
Created
October 6, 2021 18:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * | |
| FROM SFFind_Neighborhoods | |
| LIMIT 10 |
afcotroneo
/ omni-scp-create-table.sql
Created
October 6, 2021 18:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE SFFind_Neighborhoods ( | |
| LINK TEXT ENCODING DICT(32, | |
| the_geom GEOMETRY(POLYGON, 4326) ENCODING COMPRESSED(32), | |
| name TEXT ENCODING DICT(32) | |
| ); |
afcotroneo
/ omni-scp-copy-from.sql
Last active
October 6, 2021 18:27
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| COPY SFFind_Neighborhoods FROM '/omnisci-storage/data/mapd_import/SFFind_Neighborhoods.csv' |
afcotroneo
/ omni-scp-ls
Created
October 6, 2021 18:13
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [my-instance-user-name@my-instance-IPv6-address ~] ls | |
| nypd_complaints_slimmed.csv SFFind_Neighborhoods.csv |
afcotroneo
/ omni-scp-sudo-cp
Created
October 6, 2021 17:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| sudo cp SFFind_Neighborhoods.csv /var/lib/omnisci/omnisci-storage/data/mapd_import |
afcotroneo
/ omni-scp-sure
Last active
October 6, 2021 17:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| The authenticity of host 'my-instance-public-dns-name (IPv6)' can't be established. | |
| RSA key fingerprint is 1f:51:ae:28:bf:89:e9:d8:1f:25:5d:37:2d:7d:b8:ca:9f:f5:f1:6f. | |
| Are you sure you want to continue connecting (yes/no)? |
afcotroneo
/ omni-scp-success
Last active
October 6, 2021 17:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Warning: Permanently added 'my-instance-public-dns-name' (RSA) to the list of known hosts. | |
| SFFind_Neighborhoods.csv 100% 480 24.4KB/s 00:00 |