Dremio connection with stata

1

There is a way to connect dremio with stata?

2

It looks like Stata supports ODBC and you may be able to use our ODBC driver to connect it to Dremio.

3

Yeah. When I try to connect, it’s works.
But I can’t access the data…

When I tried to load the table, I got this error:

. odbc load, table("teste_tabela.xlsx")

The ODBC driver reported the following diagnostics
[Dremio][Connector] (1040) Dremio failed to execute the query: SELECT * FROM
“teste_tabela.xlsx”
[30038]Query execution error. Details:[
VALIDATION ERROR:
Table ‘teste_tabela.xlsx’ not found

SQL Query SELECT * FROM
“teste_tabela.xlsx”
startLine 1
startColumn 15
endLine 1
endColumn 33

[Error
Id: 4eb820bd-4027-42e3-a877-51b3db8e6cb5 on NoteOpe27.OPORTUNIDADES.es:31010]

(org.apache.calcite.runtime.CalciteContextException) From line 1, column 15 to
line 1, column 33: Table ‘teste_tabela.xlsx’ not found

sun.reflect.GeneratedConstructorAccessor216.newInstance():-1

sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45

java.lang.reflect.Constructor.newInstance():423

org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463

org.apache.calcite.sql.SqlUtil.newContextException():803

org.apache.calcite.sql.SqlUtil.newContextException():788

org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470

org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104

org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120

org.apache.calcite.sql.validate.AbstractNamespace.validate():84

org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943

org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924

org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971

org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956

org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197

org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60

org.apache.calcite.sql.validate.AbstractNamespace.validate():84

org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943

org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924

org.apache.calcite.sql.SqlSelect.validate():226

org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899

org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609

com.dremio.exec.planner.sql.SqlConverter.validate():199

com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177

com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166

com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162

com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43

com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69

com.dremio.exec.work.foreman.AttemptManager.run():288

java.util.concurrent.ThreadPoolExecutor.runWorker():1149

java.util.concurrent.ThreadPoolExecutor$Worker.run():624

java.lang.Thread.run():748
Caused By
(org.apache.calcite.sql.validate.SqlValidatorException) Table
‘teste_tabela.xlsx’ not found

sun.reflect.GeneratedConstructorAccessor218.newInstance():-1

sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45

java.lang.reflect.Constructor.newInstance():423

org.apache.calcite.runtime.Resources$ExInstWithCause.ex():463

org.apache.calcite.runtime.Resources$ExInst.ex():572

org.apache.calcite.sql.SqlUtil.newContextException():803

org.apache.calcite.sql.SqlUtil.newContextException():788

org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError():4470

org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl():104

org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl():120

org.apache.calcite.sql.validate.AbstractNamespace.validate():84

org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943

org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924

org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2971

org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom():2956

org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect():3197

org.apache.calcite.sql.validate.SelectNamespace.validateImpl():60

org.apache.calcite.sql.validate.AbstractNamespace.validate():84

org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace():943

org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery():924

org.apache.calcite.sql.SqlSelect.validate():226

org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression():899

org.apache.calcite.sql.validate.SqlValidatorImpl.validate():609

com.dremio.exec.planner.sql.SqlConverter.validate():199

com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode():177

com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():166

com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():162

com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():43

com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():69

com.dremio.exec.work.foreman.AttemptManager.run():288

java.util.concurrent.ThreadPoolExecutor.runWorker():1149

java.util.concurrent.ThreadPoolExecutor$Worker.run():624

java.lang.Thread.run():748

]
SQLSTATE=HY000
r(682);

.