With JDBC, both will already work.

pstmt.setString("STOCK_NAME", stockName);

pstmt.setString(1, stockName);


On Tuesday, January 5, 2016, anil gupta <[email protected]> wrote:

> 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
> following example:
>
> @Override
>     public void write(PreparedStatement pstmt) throws SQLException {
>        pstmt.setString(1, stockName);
>        pstmt.setDouble(2, maxPrice);
>     }
>
> There are couple of problems with above:
> 1. What if someone deletes a column from table? My guess, It will change
> index of some of the columns. Right?(Lets say, a table has 5 columns. 3rd
> column of table is deleted.)
> 2. Readability of code is also less since column names are denoted by
> numbers.(in reality it's a name/value pair)
>
> Instead, if we have following API then it will be much easier and above
> problems will be fixed:
>
> @Override
>     public void write(PreparedStatement pstmt) throws SQLException {
>        pstmt.setString("STOCK_NAME", stockName);
>        pstmt.setDouble("MAX_RECORDING", maxPrice);
>     }
>
> Also, my coding habits are giving me hard time to code on basis of index when 
> in reality its a key/value pair. :)
>
> Is there anyway i can achieve the above? Would the community like to have the 
> key/value api?
>
>
> --
> Thanks & Regards,
> Anil Gupta
>

Reply via email to