I’m adding [email protected] mailing list as this seems to be normal user question Please do register in the mailing list Pablo, you can find instructions in [1].
Could you share with us your entire Sqoop command line? Jarcec 1: http://sqoop.apache.org/mail-lists.html > On May 1, 2015, at 1:10 AM, Pablo Torre <[email protected]> wrote: > > Hi Jarek. > > I am taking a look at code in Sqoop 1.4.5 and in the java class > Sqlmanager.java I can see that it is using "SELECT TIMESTAMP;" instead of use > "SELECT TIMESTAMP()". But I still get the error > "com.microsoft.sqlserver.jdbc.SQLServerException: Incorrent sintaxis near to > ')'." > > I was testing it in Microsoft SQL Server Management and If I run the query > "SELECT TIMESTAMP()" I get the same error. > > I don't know why sqoop is trying to execute the wrong query if the source > code is right. > > Please help me with this. > > > > 2015-04-20 16:41 GMT+02:00 Jarek Jarcec Cecho <[email protected]>: > I believe that this is already fixed in Sqoop 1.4.5. I would suggest to sign > up to Sqoop user mailing list (instructions are at [1]) and ask for help :) > > Jarcec > > Links: > 1: http://sqoop.apache.org/mail-lists.html > > > On Apr 19, 2015, at 2:12 PM, Pablo Torre <[email protected]> wrote: > > > > Thanks Jarek, > > > > I was using Sqoop 1.4.5, maybe I have to install a new version or update > > the code. > > > > Best, > > Pablo > > > > 2015-04-19 20:42 GMT+02:00 Jarek Jarcec Cecho <[email protected]>: > > Hi Pablo, > > I’m always excited to see a new contributor on Sqoop project. Take a look > > at quick “How to contribute” wiki page that contains all the details about > > how to contribute to Sqoop: > > > > https://cwiki.apache.org/confluence/display/SQOOP/How+to+Contribute > > > > For your particular issue, I feel that it’s long solved as the Microsoft > > Sql connector is already using the correct query, check out the latest > > source code: > > > > https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/manager/SQLServerManager.java#L251 > > > > Jarcec > > > > > On Apr 17, 2015, at 2:24 AM, Pablo Torre <[email protected]> wrote: > > > > > > Hi Jarcec, > > > > > > My name is Pablo. I am writing this email because I saw that you are > > > working on the project sqoop on github. https://github.com/apache/sqoop > > > > > > There is a bug that I would like to share with you and maybe you can help > > > me and say me how can I modified the source code or contribute to the > > > project: > > > > > > I am trying to use incremental imports with sqoop using the option > > > lastmodified, but with MS SQLSERVER fails. I found this article about it > > > https://issues.cloudera.org/browse/SQOOP-229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel > > > > > > "I see in the source code for SqlManager.java that the query being used > > > in getCurTimestampQuery() is "select CURRENT_TIMESTAMP()" this is not > > > compatible with MSSQL - for MSSQL it would be just "select > > > CURRENT_TIMESTAMP" (keyword not a function)." > > > > > > I would like to modify that class and compile the code to get it working. > > > But I don't know how to do it. > > > > > > Do you know if there is any patch for it? > > > If you can help me with this issue. > > > > > > Thanks. > > > > > > My Github: https://github.com/sylvinho81 > > > > > > -- > > > Pablo Torre. > > > Freelance software engineer and Ruby on Rails developer. > > > Oleiros (Coruña) > > > Personal site > > > My blog > > > > > > > > > > -- > > Pablo Torre. > > Freelance software engineer and Ruby on Rails developer. > > Oleiros (Coruña) > > Personal site > > My blog > > > > > -- > Pablo Torre. > Freelance software engineer and Ruby on Rails developer. > Oleiros (Coruña) > Personal site > My blog
