 |
Qwert |
at Sep 24, 2013 at 9:36 am
|
⇧ | 
| |
hi Murali,
I have a problem when select from impala based on linked server, which
based on ODBC driver v2.5.2.1002 for Impala.
Is this your case here too?
If yes, I want to know whether there is a string/varchar/text column in
your selecting table?
Since if only int type column in table, no problem;
but if string/varchar/text column, then error messages as below.
OLE DB provider "MSDASQL" for linked server "ImpalaDW" returned message
"Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 2
Cannot get the current row value of column "[MSDASQL].sessionid" from OLE
DB provider "MSDASQL" for linked server "ImpalaDW".
Thanks.
On Thursday, September 19, 2013 11:06:18 PM UTC+8, Murali Dhar wrote:I got it. My ODBC set up for Impala was not right. I did choose
Authentication = no before and I did choose "user name" now. Once I chaneg
my authentication, I am able to pull the data from Impala view.
Thanks for your help.
On Wed, Sep 18, 2013 at 3:57 PM, James Duong <duong...@gmail.com<javascript:>
wrote:
Hi Murali,
Can you describe the columns in the demo table?
Try selecting them one-by-one using Linked Server and see if the problem
is isolated to a specific data type.
On Monday, 16 September 2013 15:05:49 UTC-7, Murali Dhar wrote:
I found a white paper on "SQL Server Analysis Services to Hive" and
configured fine. Same way I configured to Impala and tested the
connectivity fine. But I was not able to create views while using Impala
via command...
CREATE VIEW sample_08 AS
SELECT * FROM OpenQuery(IMPALA, 'SELECT * FROM demo;')
Error I am getting:
OLE DB provider "MSDASQL" for linked server "IMPALA" returned message
"[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala:
[HY000] : Error: Error: could not match input".
Msg 7321, Level 16, State 2, Procedure sample_08, Line 2
An error occurred while preparing the query "SELECT * FROM demo;" for
execution against OLE DB provider "MSDASQL" for linked server "IMPALA".
Please advise us.
Enclosed Microsoft white paper.
--
---
You received this message because you are subscribed to a topic in the
Google Groups "CDH Users" group.
To unsubscribe from this topic, visit
https://groups.google.com/a/cloudera.org/d/topic/cdh-user/Xc4DUwa2qOQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
cdh-user+u...@cloudera.org <javascript:>.
For more options, visit
https://groups.google.com/a/cloudera.org/groups/opt_out. --
---
You received this message because you are subscribed to the Google Groups "CDH Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cdh-user+unsubscribe@cloudera.org.
For more options, visit
https://groups.google.com/a/cloudera.org/groups/opt_out.
