su: ignoring --preserve-environment, it's mutually exclusive with --login
Linking to GEOS 3.12.1, GDAL 3.8.4, PROJ 9.4.0; sf_use_s2() is TRUE
── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
✔ dplyr 1.1.4 ✔ readr 2.1.5
✔ forcats 1.0.0 ✔ stringr 1.5.1
✔ ggplot2 3.5.1 ✔ tibble 3.2.1
✔ lubridate 1.9.3 ✔ tidyr 1.3.1
✔ purrr 1.0.2
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag() masks stats::lag()
ℹ Use the conflicted package () to force all conflicts to become errors
Attaching package: ‘shinydashboard’
The following object is masked from ‘package:graphics’:
box
Attaching package: ‘magrittr’
The following object is masked from ‘package:purrr’:
set_names
The following object is masked from ‘package:tidyr’:
extract
Attaching package: ‘plotly’
The following object is masked from ‘package:ggplot2’:
last_plot
The following object is masked from ‘package:stats’:
filter
The following object is masked from ‘package:graphics’:
layout
Loading required package: sp
Please note that rgdal will be retired during October 2023,
plan transition to sf/stars/terra functions using GDAL and PROJ
at your earliest convenience.
See https://r-spatial.org/r/2023/05/15/evolution4.html and https://github.com/r-spatial/evolution
rgdal: version: 1.6-7, (SVN revision 1203)
Geospatial Data Abstraction Library extensions to R successfully loaded
Loaded GDAL runtime: GDAL 3.8.4, released 2024/02/08
Path to GDAL shared files: /usr/share/gdal
GDAL does not use iconv for recoding strings.
GDAL binary built with GEOS: TRUE
Loaded PROJ runtime: Rel. 9.4.0, March 1st, 2024, [PJ_VERSION: 940]
Path to PROJ shared files: /home/shiny/.local/share/proj:/usr/share/proj
PROJ CDN enabled: FALSE
Linking to sp version:2.1-4
To mute warnings of possible GDAL/OSR exportToProj4() degradation,
use options("rgdal_show_exportToProj4_warnings"="none") before loading sp or rgdal.
Listening on http://127.0.0.1:41029
Warning: The select input "sele1" contains a large number of options; consider using server-side selectize for massively improved performance. See the Details section of the ?selectizeInput help topic.
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#57]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '11' AND substr(id_setor_mundest, 1, 2) = '11' AND durations < 180 AND destin_mun IN (110012,110020)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#79]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#57]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180 AND destin_mun IN (130260,130340,130406)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#79]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '13' AND substr(id_setor_mundest, 1, 2) = '13' AND durations < 180 AND destin_mun IN (130260,130340,130406)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '12' AND substr(id_setor_mundest, 1, 2) = '12' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '12' AND substr(id_setor_mundest, 1, 2) = '12' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '12' AND substr(id_setor_mundest, 1, 2) = '12' AND durations < 180 AND destin_mun IN (120040)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '43' AND substr(id_setor_mundest, 1, 2) = '43' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '43' AND substr(id_setor_mundest, 1, 2) = '43' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '43' AND substr(id_setor_mundest, 1, 2) = '43' AND durations < 180 AND destin_mun IN (430510,431020,431410,431440,431490,431680,431690)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '43' AND substr(id_setor_mundest, 1, 2) = '43' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '43' AND substr(id_setor_mundest, 1, 2) = '43' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '43' AND substr(id_setor_mundest, 1, 2) = '43' AND durations < 180 AND destin_mun IN (430510,431020,431410,431440,431490,431680,431690)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '35' AND substr(id_setor_mundest, 1, 2) = '35' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '35' AND substr(id_setor_mundest, 1, 2) = '35' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '35' AND substr(id_setor_mundest, 1, 2) = '35' AND durations < 180 AND destin_mun IN (350600,350950,351630,351880,352590,352900,353440,353870,354140,354340,354850,354870,354980,354990,355030,355220,355280)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations < 180 AND destin_mun IN (330100,330455,330630)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#57]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '33' AND substr(id_setor_mundest, 1, 2) = '33' AND durations < 180 AND destin_mun IN (330100,330455,330630)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#79]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '26' AND substr(id_setor_mundest, 1, 2) = '26' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '26' AND substr(id_setor_mundest, 1, 2) = '26' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#57]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '26' AND substr(id_setor_mundest, 1, 2) = '26' AND durations < 180 AND destin_mun IN (260410,261110,261160,261390)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#79]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Connection is garbage-collected, use dbDisconnect() to avoid this.
Warning: Error in cat: argument 1 (type 'list') cannot be handled by 'cat'
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT DISTINCT ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) AS CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '26' AND substr(id_setor_mundest, 1, 2) = '26' AND durations <
180
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: WHERE substring(destin_mun,1,2) = '26' AND substr(id_setor_mundest, 1, 2) = '26' AND durations <
180...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#58]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf1
1: runApp
Warning: Error in : rapi_prepare: Failed to prepare query SELECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1, 15) as CD_SETOR, durations FROM tb_resul_all_new
WHERE substring(destin_mun,1,2) = '26' AND substr(id_setor_mundest, 1, 2) = '26' AND durations < 180 AND destin_mun IN (260410,261110,261160,261390)
Error: Binder Error: No function matches the given name and argument types 'substring(INTEGER, INTEGER_LITERAL, INTEGER_LITERAL)'. You might need to add explicit type casts.
Candidate functions:
substring(VARCHAR, BIGINT, BIGINT) -> VARCHAR
substring(VARCHAR, BIGINT) -> VARCHAR
LINE 2: ...LECT distinct ON (substr(id_setor_mundest, 1, 15)) substr(id_setor_mundest, 1,...
^
176: rapi_prepare
175: .local
174: dbSendQuery
172: .local
171: dbGetQuery
169: conn_banco_duck
168: renderPlot [/dados/htdocs/shiny.icict.fiocruz.br/sent_infogripe/server.R#80]
166: func
126: drawPlot
112:
96: drawReactive
83: renderFunc
82: output$graf2
1: runApp
Execution halted
Warning messages:
1: Connection is garbage-collected, use dbDisconnect() to avoid this.
2: Connection is garbage-collected, use dbDisconnect() to avoid this.