colinf2[ 2 ].setComboValues( ColumnFilter.ComparisonType.getAllOperators() ); colinf2[ 5 ].setComboValues( new String[] { "Y", "N" } );
ColumnFilter f = columnFilterFactory.createFilter( alias ); f.setFieldType( type ); f.setComparisonOperator( ColumnFilter.ComparisonType.stringToOpp( operator ) ); f.setConstant( comparison ); f.setSignedComparison( signed.equalsIgnoreCase( "Y" ) );
item.setText( 3, f.getComparisonOperator().toString() );
public String[] getComboValues( TableItem tableItem, int rowNr, int colNr ) { String[] comboValues = colinf2[ 2 ].getComboValues(); // try to fill in the type String alias = tableItem.getText( 1 ); HBaseValueMetaInterface vm = null; if ( !Const.isEmpty( alias ) ) { vm = setFilterTableTypeColumn( tableItem ); } if ( vm != null ) { if ( vm.isNumeric() || vm.isDate() || vm.isBoolean() ) { comboValues = ColumnFilter.ComparisonType.getNumericOperators(); } else if ( vm.isString() ) { comboValues = ColumnFilter.ComparisonType.getStringOperators(); } else { comboValues = new String[ 1 ]; comboValues[ 0 ] = ""; } } else { // if we've not got a connection, or there is no user-specified // columns saved in the meta class, then just get all the // operators comboValues = ColumnFilter.ComparisonType.getAllOperators(); } return comboValues; } } );
@Override public void addColumnFilterToScan( ColumnFilter cf, HBaseValueMetaInterface columnMeta, final VariableSpace vars, final boolean matchAny ) throws IOException { final org.pentaho.hbase.shim.api.ColumnFilter columnFilter = new org.pentaho.hbase.shim.api.ColumnFilter( cf.getFieldAlias() ); columnFilter.setFormat( cf.getFormat() ); columnFilter.setConstant( cf.getConstant() ); columnFilter.setSignedComparison( cf.getSignedComparison() ); columnFilter.setFieldType( cf.getFieldType() ); columnFilter.setComparisonOperator( org.pentaho.hbase.shim.api.ColumnFilter.ComparisonType.valueOf( cf.getComparisonOperator().name() ) ); final HBaseValueMetaInterfaceImpl hBaseValueMetaInterface = hBaseValueMetaInterfaceFactory.copy( columnMeta ); batchHBaseConnectionOperation.addOperation( new HBaseConnectionOperation() { @Override public void perform( HBaseConnectionWrapper hBaseConnectionWrapper ) throws IOException { try { hBaseConnectionWrapper .addColumnFilterToScan( columnFilter, hBaseValueMetaInterface, vars, matchAny ); } catch ( Exception e ) { throw new IOException( e ); } } } ); }
public static String[] getNumericOperators() { return new String[] { ColumnFilter.ComparisonType.EQUAL.toString(), ColumnFilter.ComparisonType.NOT_EQUAL.toString(), ColumnFilter.ComparisonType.GREATER_THAN.toString(), ColumnFilter.ComparisonType.GREATER_THAN_OR_EQUAL.toString(), ColumnFilter.ComparisonType.LESS_THAN.toString(), ColumnFilter.ComparisonType.LESS_THAN_OR_EQUAL.toString() }; }
@Override public void setComparisonOperator( ComparisonType c ) { if ( c == null ) { delegate.setComparisonOperator( null ); } else { delegate.setComparisonOperator( org.pentaho.hbase.shim.api.ColumnFilter.ComparisonType.valueOf( c.name() ) ); } }
@Override public ComparisonType getComparisonOperator() { org.pentaho.hbase.shim.api.ColumnFilter.ComparisonType comparisonOperator = delegate.getComparisonOperator(); if ( comparisonOperator == null ) { return null; } return ComparisonType.valueOf( comparisonOperator.name() ); }
@Override public ColumnFilter.ComparisonType string2enum( Class<?> enumClass, String value ) throws KettleValueException { return ColumnFilter.ComparisonType.stringToOpp( value ); } }
public static String[] getAllOperators() { return new String[] { ColumnFilter.ComparisonType.EQUAL.toString(), ColumnFilter.ComparisonType.NOT_EQUAL.toString(), ColumnFilter.ComparisonType.GREATER_THAN.toString(), ColumnFilter.ComparisonType.GREATER_THAN_OR_EQUAL.toString(), ColumnFilter.ComparisonType.LESS_THAN.toString(), ColumnFilter.ComparisonType.LESS_THAN_OR_EQUAL.toString(), ColumnFilter.ComparisonType.SUBSTRING.toString(), ColumnFilter.ComparisonType.PREFIX.toString(), ColumnFilter.ComparisonType.REGEX.toString() }; }