column.getOrdinalPosition(), // ORDINAL_POSITION pkColNames.contains(column.getName().toLowerCase()) ? "NO" : "YES", // IS_NULLABLE
private List<ColumnDesc> getResultSchemaInternal(OperationHandle operationHandle) throws SQLException { ImmutableList.Builder<ColumnDesc> listBuilder = ImmutableList.builder(); if (operationHandle.hasResultSet()) { TableSchema tableSchema = cliService.getResultSetMetadata(operationHandle); for (ColumnDescriptor colDesc : tableSchema.getColumnDescriptors()) { listBuilder.add(new ColumnDesc(colDesc.getName(), colDesc.getTypeName(), colDesc.getOrdinalPosition(), colDesc.getComment())); } } return listBuilder.build(); }
private List<ColumnDesc> getResultSchemaInternal(OperationHandle operationHandle) throws SQLException { ImmutableList.Builder<ColumnDesc> listBuilder = ImmutableList.builder(); if (operationHandle.hasResultSet()) { TableSchema tableSchema = cliService.getResultSetMetadata(operationHandle); for (ColumnDescriptor colDesc : tableSchema.getColumnDescriptors()) { listBuilder.add(new ColumnDesc(colDesc.getName(), colDesc.getTypeName(), colDesc.getOrdinalPosition(), colDesc.getComment())); } } return listBuilder.build(); }
private void assertResultsAreEqual(ESResultSet resultSet1, ESResultSet resultSet2) { final Collection<ColumnDescriptor> columns1 = resultSet1.getMetadata().getColumns(); final Collection<ColumnDescriptor> columns2 = resultSet2.getMetadata().getColumns(); Assert.assertEquals(columns1.size(), columns2.size()); final Iterator<ColumnDescriptor> iterator1 = columns1.iterator(); final Iterator<ColumnDescriptor> iterator2 = columns2.iterator(); while (iterator1.hasNext()) { final ColumnDescriptor column1 = iterator1.next(); final ColumnDescriptor column2 = iterator2.next(); Assert.assertEquals("Column aliases are different! " + column1.getName() + " " + column1.getName(), column1.getName(), column2.getName()); Assert.assertEquals("Column positions are different! " + column1.getName() + " " + column1.getName(), column1.getOrdinalPosition(), column2.getOrdinalPosition()); Assert.assertEquals("Column types are different! " + column1.getName() + " " + column1.getName(), column1.getType(), column2.getType()); } Assert.assertEquals(resultSet1.size(), resultSet2.size()); while (resultSet1.hasNext()) { final ResultRow row1 = resultSet1.next(); final ResultRow row2 = resultSet2.next(); Assert.assertEquals("Row length is different", row1.getValues().size(), row2.getValues().size()); Iterator<Object> values1 = row1.getValues().iterator(); Iterator<Object> values2 = row2.getValues().iterator(); while (values1.hasNext()) { Assert.assertEquals("Values are different", values1.next(), values2.next()); } } }
column.getOrdinalPosition(), // ORDINAL_POSITION pkColNames.contains(column.getName().toLowerCase()) ? "NO" : "YES", // IS_NULLABLE
@Override public void serialize(ColumnDescriptor columnDescriptor, JsonGenerator jsonGenerator, SerializerProvider serializerProvider) throws IOException, JsonProcessingException { jsonGenerator.writeStartObject(); jsonGenerator.writeStringField("name", columnDescriptor.getName()); jsonGenerator.writeStringField("comment", columnDescriptor.getComment()); jsonGenerator.writeNumberField("position", columnDescriptor.getOrdinalPosition()); jsonGenerator.writeStringField("type", columnDescriptor.getType().getName()); jsonGenerator.writeEndObject(); } });
@Override public void serialize(ColumnDescriptor columnDescriptor, JsonGenerator jsonGenerator, SerializerProvider serializerProvider) throws IOException, JsonProcessingException { jsonGenerator.writeStartObject(); jsonGenerator.writeStringField("name", columnDescriptor.getName()); jsonGenerator.writeStringField("comment", columnDescriptor.getComment()); jsonGenerator.writeNumberField("position", columnDescriptor.getOrdinalPosition()); jsonGenerator.writeStringField("type", columnDescriptor.getType().getName()); jsonGenerator.writeEndObject(); } });
column.getOrdinalPosition(), // ORDINAL_POSITION "YES", // IS_NULLABLE
column.getOrdinalPosition(), // ORDINAL_POSITION "YES", // IS_NULLABLE
column.getOrdinalPosition(), // ORDINAL_POSITION "YES", // IS_NULLABLE
column.getOrdinalPosition(), // ORDINAL_POSITION "YES", // IS_NULLABLE