Re: Phoenix MR integration api only accepts Index of column for setting column value

2016-01-06 Thread James Taylor
My mistake - I was thinking of ResultSet.getString(String,String) and ResultSet.getString(int,String). PreparedStatement sets parameters based on the order you list the ? In your statement - they don't necessarily map to columns at all. These are all standard JDBC interfaces, not defined by Phoenix

Re: Phoenix MR integration api only accepts Index of column for setting column value

2016-01-06 Thread anil gupta
Hi James, Maybe, i am missing your point. I dont see following method in PreparedStatement interface: pstmt.setString("STOCK_NAME", stockName); Do i need to use some other stuff than Phoenix MR integration to get that method? Thanks, Anil Gupta On Tue, Jan 5, 2016 at 8:48 PM, James Taylor

Re: Phoenix MR integration api only accepts Index of column for setting column value

2016-01-05 Thread James Taylor
With JDBC, both will already work. pstmt.setString("STOCK_NAME", stockName); pstmt.setString(1, stockName); On Tuesday, January 5, 2016, anil gupta wrote: > Hi, > > I am using Phoenix4.4. I am trying to integrate my MapReduce job with > Phoenix following this doc: https://phoenix.apache.org/p

Phoenix MR integration api only accepts Index of column for setting column value

2016-01-05 Thread anil gupta
Hi, I am using Phoenix4.4. I am trying to integrate my MapReduce job with Phoenix following this doc: https://phoenix.apache.org/phoenix_mr.html My phoenix table has around 1000 columns. I have some hesitation regarding using *COLUMN_INDEX* for setting its value rather than *NAME* as per followi